Re: Case Insensitive search [corrected]

>> Thank you to wyang <wyang@aerotek.com> for pointing out my erroneous >> case insensitive where clause -- that's what I get for shooting something >> off too quickly without proofing or testing it! Let's try again: Try including something like this if you are looking for "cat": ...where table.field matches "[Cc][Aa][Tt]" you can also attach an asterisk or two if this string is embedded. ...where table.field matches "*[Cc][Aa][Tt]*" although this will slow down the query significantly. At 08:45 PM 8/16/96 GMT, you wrote: >How to Query on the database for all character or string fields >to be a case insensitive search particularly on informix db engine ? > >Please e-mail responses to > vshekar@hpbs3781.boi.hp.com > >Thanks >Shekar > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Darrell S. Thacher dthacher@gte.net IntegriSoft, Inc. 817-430-8410 (voice) 6524 Burning Tree Drive 817-430-4495 (fax) Flower Mound, TX 75028