Re: <No Subject Supplied>

Allen, I wouldn't call it a trick but the following expression would be case insensitive: MATCHES "[Vv][Ii][Ss][Tt][Aa]" I believe Dennis Pimple even posted a function once that would take a passed in parameter and create a case insensitive search string for it. On Tue, 9 Apr 1996 16:22:12 -0500, agu@ai.org (Allen Gu) wrote: >>From my understanding, Informix SQL keyword "MATCHES" is case sensitive. That is, you can use "ISTA" to match "ISTA" or "VISTA", but not "Ista" not "ista". > >However, is there a trick in SQL to make "MATCHES" work for even fields composed of characters of different cases? > ====================================================================== Craig Kickel | Unix/C/Database Consultant ckickel@cyberhighway.net | <This space intentionally left blank> ======================================================================