Re: Case-insensitive search solution wanted

Posted in 1994

Kevin Wonus — Mon, 21 Nov 1994 21:17:34 GMT — source: Informix-list mailing list archive (1991-1998)

Trevor Reynolds (trevor@caerlas.demon.co.uk) wrote: : Please copy any response to the news group as I am sure they will be : of general interest (or at least copy them to me!) It is quite sloppy, but searching for John Doe, you can use the non- standard matches operator: WHERE NameFull matches "[Jj][Oo][Hh][Nn] [Dd][Oo][Ee]" The problem is performance. If you need rapid response (i.e. you have a very large database), you will need a redundant field which contains an all lower case version of the string. (or perhaps an additional field which has a capitalization rule... you have to beware of last names such as O'Reily or Van Elswyk) ---> kevin.