Subject Re: [ib-support] Case sensitive
Author Nando Dessena
German,

G> select field
G> from table
G> where field containing '%bird'

G> ??

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

unfortunately no, wildcards are supported by LIKE only.
Others way to go include mirroring fields in UPPER() versions and case
insensitive collations. The archives abound of articles about how to
do just that.

Ciao
--
Nando mailto:nandod@...