and.... Can I perform something like:

select field
from table
where field containing '%bird'

??

It returns all rows ending with 'bird' string using a case insensitive
search way.

thanks,
yerman



At 02:53 PM 09/04/2003 +0200, you wrote:

>At 09:08 09.04.2003 -0300, you wrote:
> >Can I use CONTAINING statement as well as LIKE statement ? that is,
> >searching for a substring ?
>
>CONTAINING is case insensitive, whereas LIKE is case sensitive.
>
>HTH,
>Set
>
>
>
>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/

-------------------------------------------------------
A.C. German Terrazas Angulo
L.I.F.I.A. - Facultad de Informatica
Universidad Nacional de La Plata
Buenos Aires - Argentina
Tel/Fax: (54 221) 4228252 / 4236585
-------------------------------------------------------