Re: Case-INSENSITIVE searches?? Possible??

Glad to help

Alex Skolnic wrote:

> 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 Thu Mar 29 2001 - 06:57:40 CST