LIKE is case sensitive, that's why I'd like to have a flag to tell it not to
be. I can go either way, by changing the LIKE command or the CONTAINING
command. The problem is you have to sacrifice one thing for the other
depending on which command you want to use. CONTAINING finds the string
anywhere inside the field and LIKE let's you specify the string using wild
cards.

Woody

----- Original Message -----
From: <hans@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, September 03, 2001 6:42 PM
Subject: Re: [ib-support] containing, like, =


> >I hope there are plans for future IB
> >versions to have a case-sensitive flag for the like command
>
> I thought LIKE was case sentive and LIKE 'NAME%' does use an index,
> but LIKE '%NAME%' does not. However CONTAINS 'NAME' is case
> in-sensitive and doesn't use an index.
>
> Hans
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>