Re: Case-INSENSITIVE searches?? Possible??

Thanks David!!

It's amazing how simple it was to do.

Thanks again!
Alex

On Wed, 28 Mar 2001 13:42:38 -0600, David Busby <dbusby3_at_slb.com> wrote:

>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 - 16:28:26 CST