--- In firebird-support@yahoogroups.com, Uwe Grauer
<mailinglists@o...> wrote:

> 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

Thank you! Works great!