Re: Case insensitive LIKE/MATCHES in WHERE clause.

kafts@fullfeed.fullfeed.com (Steve Kaftanski) writes: > 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? This is not a *good* way, but you can have your WHERE clause say: WHERE column MATCHES "[Aa][Bb]*" The best rule is, whenever possible, force uppercase or lowercase on data before inserting it into the database. ================ Dennis J. Pimple Informix CSE / Denver 303-850-0210 > I couldn't find any documentation on this in any of the manuals. >Thanx much, >Mike Lange >kafts@fullfeed.com