Re: How do I do a CASE INsensitive search in INFORMIX ver. 7.x?

Posted in 1998

Jonathan Leffler — Mon, 26 Oct 1998 20:30:26 -0800 — source: Informix-list mailing list archive (1991-1998)

Jeff & Baxi wrote: > > I'm new to Informix and have not found the command for doing a case > insensitive search. (e.g in mSQL you can convert things using LOWER( ) > for matching). Is their something equivalent in Informix? It depends on whether the X in 7.x is 3 or some smaller number. In 7.30 and above, you can use UPPER() and LOWER(). In earlier versions, you have to get the excruciatingly slow stored procedures from the IIUG web site. This is a FAQ too. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>