Subject | Re: [ib-support] Case sensitive |
---|---|
Author | Nando Dessena |
Post date | 2003-04-09T15:05:19Z |
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@...
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@...