You should use where field like '%bird%'

----- Original Message -----
From: "German Terrazas Angulo" <german@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, April 08, 2003 5:24 PM
Subject: [ib-support] HELP using like statement


> hi,
>
> Does any body know how to use LIKE statement with % ? That is,
>
> select field
> from Table
> where field like %bird%
>
> it returns all columns named field where it contains "bird" as part of the
> value.
>
> thanks,
> yerman
>
>
>
> 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/
>