On Thursday 2001-09-13 at 18:56:53 +0200, Nando Dessena wrote:

> Paul,
>
> > LIKE '%XY%' works in exactly the same way as STARTING WITH, i.e. it is
> > optimised the same way if an index is there is will be used.
>
> I think you meant LIKE 'XY%' here.

Personally, I don't recall having any success with 'XY%' and for some
unknown reason have always had to use '%XY%'. Seems weird to me, but
that has been my experience.

David Trudgett