How can I do a case insensitive search?

Posted in 1999

fschuppenhauer@my-dejanews.com — Wed, 20 Jan 1999 12:12:18 GMT — source: Informix-list mailing list archive (1991-1998)

How can I do a case insensitive string search? I didn't found any answers to this question in the FAQ. Thanx for your help. Greetings Fin. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

↪ replying to fschuppenhauer@my-dejanews.com

Thomas J. Girsch — Thu, 21 Jan 1999 13:24:08 -0500 — source: Informix-list mailing list archive (1991-1998)

If you have IDS 7.3x, you can do: SELECT * FROM table WHERE UPPER(string1) = UPPER(string2); fschuppenhauer@my-dejanews.com wrote in message <784h6t$1j9$1@nnrp1.dejanews.com>... >How can I do a case insensitive string search? > >I didn't found any answers to this question in the FAQ. > >Thanx for your help. > > > Greetings Fin. > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own