Re: Case INsensitive search

On way to get around it is to use MATCHES predicate. For example: SELECT * FROM customer WHERE name MATCHES "[Jj][Oo]..." Check the manuals for exact syntax. -------------------------------------------------------------------------------------------------------------------- Rafal Czerniawski Dataspace Consulting Pty Ltd Sydney, Australia Email: rafal@magna.com.au leblancs@tsagate.com (Sean LeBlanc) wrote: >We are using Informix as one of our database backends for a product of ours. >Practically all other db's support the function "upper" in embedded SQL, which >allows us to do a case insensitive search, but Informix seems to be lacking >this functionality. (*NOTE*: I called Informix tech support for Dynamic >Server, and they were not too helpful) >What I want to be able to do is, given criteria like "jones", I want to be >able to find stuff like "Jones", "JONES", "JoNeS", etc. >If anyone know a workaround that is somewhat sane, without building a huge >IN clause or the like, please enlighten me. I could use some enlightenment. :) >TIA, >............................................................ >#include <smiley.h> >Sean LeBlanc - leblancs@tsagate.com >Quote o' the moment: >"You can't fight in here, this is the WAR room!" >#define STD_DISCLAIMER "My words are my own."