Re: case insensitive search

There are some solutions in the FAQ. The best if you require high speed searches is to add an adittional field to the table and maintain the upper (or lower) case version of whatever you want to search for in that field. An upper/lower function is also announced by Informix for the 7.3 version of OnLine, and it is in the Universal Server of course. "Systems Software Department" <vladimir@ssd.neca.nec.com.au> wrote: :Hello : :Does anybody know the way to make a search on a string field case :insensitive? : :VR : :NEC Australia 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