From: "Alan Scott" <balanscott@...>

> We have an automotive database in Interbase and I need to return all the
> records from a table where SEDAN was anywhere in the description field.
>
> I tried:
> select * from cardetail_carseries where description like '%SEDAN%'
>
> it errored. How would I do this...
> Thanks...

Use the CONTAINING keyword:

select * from cardetail_carseries where description containing "sedan"

The CONTAINING clause is not case-sensitive and it will find the occurance
anywhere in the string.

HTH
Woody