Subject Re: [ib-support] HELP using like statement
Author Nando Dessena
German,

G> Does any body know how to use LIKE statement with % ? That is,

G> select field
G> from Table
G> where field like %bird%

just delimit the argument you pass to LIKE with quotes:

select field
from Table
where field like '%bird%'

Ciao
--
Nando mailto:nandod@...