Re: case-insensitive search

Posted in 1996

Roland Mueller — Tue, 26 Nov 1996 09:28:41 +0100 — source: Informix-list mailing list archive (1991-1998)

Everett Barnes wrote: > > Hi. How do I do a case-insensitive search via SQL > similar to: > SELECT field(s) FROM table where key ? ''; > > LIKE 'Concord%' did not do it. > > MATCHES would require me to do do something like this: > MATCHES '[Cc][Oo][Nn][Oo][Rr][Dd]*' > > I'm sure there is an easy way. > > Please respond to everett.barnes@bankamerica.com > > Thank you, > Everett Barnes Speaking for Informix you already found the easy way, with the matches solution. Regards, Roland