Subject | Re: [ib-support] Case sensitive |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-04-09T12:41:55Z |
Hi German,
behaves like
LIKE '%somestring%'
with the difference that CONTAINING is case-insensitive, so you don't
have to UPPER() anything explicitly.
Greetings,
Paul Vinkenoog
> Can I use CONTAINING statement as well as LIKE statement ? that is,CONTAINING 'somestring'
> searching for a substring ?
behaves like
LIKE '%somestring%'
with the difference that CONTAINING is case-insensitive, so you don't
have to UPPER() anything explicitly.
Greetings,
Paul Vinkenoog