From: "ra8009" <ra8009@...>

>
> 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?
>

Use "containing" instead of LIKE. It uses case insensitive matching for most
character sets.

HTH

Woody (TMW)