Subject | Re: [ib-support] containing, like, = |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-09-03T23:42:25Z |
>I hope there are plans for future IBI thought LIKE was case sentive and LIKE 'NAME%' does use an index,
>versions to have a case-sensitive flag for the like command
but LIKE '%NAME%' does not. However CONTAINS 'NAME' is case
in-sensitive and doesn't use an index.
Hans