Subject Re: [ib-support] containing, like, =
Author hans@hoogstraat.ca
>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