You must use CONTANINING for caseinsensitive search

select * from cardetail_carseries where CONTANINING 'SEDAN';

Bye....

----- Original Message -----
From: "Alan Scott" <balanscott@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, December 04, 2001 7: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...
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>