ra8009 wrote:

>
> I'm trying to perform a search for records that contain a string of
> characters anywhere that they might appear in a VARCHAR field.
> Currently I'm using LIKE('%mystring%') to perform the search. This
> works well except that the search needs to be case insensitive. Is
> there a way to make LIKE case insensitive or is there a better way to
> do this?

select * from tbl where col containing 'blah';

Uwe