Subject Re: [IBO] Searching for a string into a string
Author Helen Borrie
At 08:16 PM 12-09-02 +0000, you wrote:
>Sorry Helen,
> > WHERE MyStringField CONTAINING 'stre'
> >
> > If MyStringField is indexed, then the case-sensitive search will
> > use the index (=fast).
>there is no way CONTAINING can use an index. STARTING [WITH] use
>indexes, but CONTAINING implies that the engine doesn't know if what
>it searches for is at the beginning of the field, and hence not where
>to lookup in an index.

Good point. :-))