Re: Case Insensitive search

Posted in 1996

"Darrell S. Thacher" — 18 Aug 1996 14:08:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Try including something like this if you are looking for "cat": ...where table.field matches "[C][c][A][a][T][t]" you can also attach an asterisk or two if this string is embedded. ...where table.field matches "*[C][c][A][a][T][t]*" 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