RE: Case-Insensitive Comparison

Posted in 1996

LESCO — 7 Sep 1996 00:13:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Yudong Sun <ysun@econnect.ca> 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. If you are requesting your data from a 4GL program or a C program after a CONSTRUCT statement, of course there is a solution ! . Dennis Pinple from Informix Sofware has wrote a function to handle it, it is called frmt_clause() and you can locate it at. http://www.iiug.org/members/memb_software/archive/noncaseqry Regards, lesco@guate.net Mario Estrada Rosa, Guatemala City, Central America Phone (502) 2318116 Fax (502) 3348447