Re: Case insensitive searches with Informix/PowerBuilder

Posted in 1996

Nils Myklebust — Thu, 17 Oct 1996 10:26:21 GMT — source: Informix-list mailing list archive (1991-1998)

"Geoff Breach" <geoffb@astea.com.au> wrote: :Hi, :I'm supporting a Powerbuilder application which, this time around, :has been installed on an Informix database. :We've struck problems with case sensitivity in searches. I know with :other database, Progress for example, I can tell the database to :ignore case when doing SELECT ... WHERE ... type stuff, so I can do :case insensitive matches. :Can anyone tell me is there such a feature in Informix, if so, how :do I make it happen. Check the FAQ. (See my signature.) Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org