What kind of field is description?
What kind of error do you get?

----- Original Message -----
From: "Alan Scott" <balanscott@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, December 04, 2001 5:32 PM
Subject: [ib-support] Substring with a specific text element


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