German;
--- In ib-support@yahoogroups.com, German Terrazas Angulo
<german@s...> wrote:

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

first you need to quote the value : '%bird%';

also you can query for anything
starting with bird : like 'bird%'
ending with bird : like '%bird'
containing bird : like '%bird%'

be aware that FB cannot use an index with the ending & containing
searches, so it can be slow. (I am not sure about index usage for
starting with searches though)

HTH
Didier

>
> thanks,
> yerman