Re: Case-Insensitive Comparison

Yudong Sun wrote: > > Could anyone tell me how to do a case-insentive comparison > in the where-clause of a SQL statement, using either = or like? > Does INFORMIX SQL provide any case conversion functions? > > Thanks a lot. > > Yudong Hi Yudong, I saw the same question some time ago. The answer was that there are no such conversion functions like for example UPPER() in Informix by default. The given solution was to use a stored procedure that does the job. Hope this helps. Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------