Re: case-insensitive search

Once again the most asked question. It's in the FAQ. Everett Barnes <everett.barnes@bankamerica.com> wrote: :Hi. How do I do a case-insensitive search via SQL :similar to: :SELECT field(s) FROM table where key ? ''; :LIKE 'Concord%' did not do it. :MATCHES would require me to do do something like this: :MATCHES '[Cc][Oo][Nn][Oo][Rr][Dd]*' This is one of the solutions given in the FAQ. :I'm sure there is an easy way. Sorry, there is another way described in the FAQ, but no easy or efficient way. There will be in Universal Server. One that is better than most. :Please respond to everett.barnes@bankamerica.com :Thank you, :Everett Barnes 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