Re: UPPER in SQL-statement

The best way is to add an extra column to the table where you allways put the upper case version of the content of your regular column and query on this. There are some other quasi solutions in the faq. "Anders Eriksson" <anders@tordata.se> wrote: :How do i compare 2 strings in informix-sql without :having to care about the up/down case in each statement??? : :example: :select text : from :table1 :where : : upper(text) like upper("HeLp Me%"); : :Thax in advance : :Anders : : 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