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. :-))

Helen