Re: <No Subject Supplied>

Craig Kickel wrote: > 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. Yes, I did. There are two 4GL solutions in the FAQ, one that takes an entire WHERE clause and parses it into an ugly MATCHES "[]" statement, and another that's a little more clever because it works with the 4.1+ CONSTRUCT ... AFTER FIELD functionality. Let me know if you need either/both (and thanks to Craig for giving me credit, whether it was due or not) -- //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer > > 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> > ======================================================================