Subject Re: [firebird-support] General conventions for Upper/Lower case searching
Author Uwe Grauer
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