Re: Case insensitive LIKE/MATCHES in WHERE clause.

Posted in 1994

Bruce Momjian — Fri, 11 Feb 1994 00:09:19 GMT — source: Informix-list mailing list archive (1991-1998)

Steve Kaftanski (kafts@fullfeed.fullfeed.com) wrote: : Is there a way to do case insensitive matches using either LIKE or : MATCHES (preferable LIKE) within a WHERE clause with Informix OnLine 4.01 : short of pulling in each row and doing a 'toupper' or something of that : sort? I needed this under Ingres SQL. The only solution I found was to create a view that uppercases the fields you are interested in and select from that. Updates and deletes are somewhat more problematic. Quite a bogus workaround, eh :-> -- Bruce Momjian | 830 Blythe Avenue root%candle.uucp@bts.com | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (215) 353-9879(w) + Christ can be your backup. | (215) 853-3000(h)