On Tuesday, 4. December 2001 18:32, Alan Scott wrote:

> 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%'

select * from cardetail_carseries where description containing 'SEDAN'

Frank

--
"Fascinating creatures, phoenixes. They can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling http://firebirdsql.org