Ray Jenkins wrote:

> We have used the contains sql term to do case insensitive searching
> here. ie. Select * from MyTable where Name contains 'Smith'
>

It's called 'containing' and doesn't use an index.
I forgot about this one.

Uwe