Re: case insensitive where clause

Check the FAQ (see my singature) for some solutions. An alternative is an extra field where you store the data in all upper or lower case and search on that (all hidden from the user). This is by now third on the list of IIUG features requests (lead only by table level backup and a Linux port) so may be Informix will implement it in the engine. fuchs@karanet.edu.uni-klu.ac.at (Florian Fuchs) wrote: :Hi! : :I am looking for a way to do case-insensitive searches like: : :SELECT * :FROM table :WHERE attribute="test"; : :which will give me all records where attribute is "test", "Test", :"TEst",... : :How can I do that? : :Thanks! : :-Florian 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