Re: Case-INSENSITIVE searches?? Possible??

From: David Busby <dbusby3_at_slb.com>
Date: Wed, 28 Mar 2001 13:42:38 -0600
Message-ID: <3AC23EAE.3735CD2@slb.com>

Try surrounding the Conditions in your where clause with an upper or lower case function. This will make everything in the evaluation of your clause the same case. Or to make it faster you could create a function based index.

Alex Skolnic wrote:

> How can I perform a case-insensitive search?
>
> I trying to perform a search on any portion of a description field
> that can be entered in Mixed case. My SQL statement is using the LIKE
> '%search%' statement, but it won't return matches that don't have the
> same case.
>
> Any ideas?
Received on Wed Mar 28 2001 - 13:42:38 CST