Subject Re: [ib-support] Case sensitive
Author Paul Vinkenoog
Hi German,

> Can I use CONTAINING statement as well as LIKE statement ? that is,
> searching for a substring ?

CONTAINING 'somestring'

behaves like

LIKE '%somestring%'

with the difference that CONTAINING is case-insensitive, so you don't
have to UPPER() anything explicitly.

Greetings,
Paul Vinkenoog