Subject | Re: [ib-support] HELP using like statement |
---|---|
Author | Nando Dessena |
Post date | 2003-04-08T20:47:34Z |
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@...
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@...