Re: Case INsensitive search with Informix?

Hello, Phil You can try the following: ... WHERE db_column matches "[Aa][Ss]_[Ss][Ee][Aa][Rr][Cc][Hh]*" Hope this helps. Regards Alexander Leites Phil_Yandel@ama-assn.org '''''''' ' '''''' <748qer$5j4$1@nnrp1.dejanews.com>... > Does anyone have any thoughts on how best to implement a case INsenstive > search against an Informix 7.23 database? With Sybase I would just code > "WHERE LOWER (db_column) = LOWER(:as_search_string)" - but, alas, Informix > doesn't seem to support either the LOWER or UPPER functions that Sybase does. > What other options are there? I really don't want to return all the > rows in the database and then filter out the ones that don't match! > > -- > Phil Yandel > Application Developer Manager > American Medical Association > > All views are my very own! > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >