| Subject | Re: [firebird-support] How to ignore the case in queries. |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2003-07-31T10:44:43Z |
Hello Ghanshyam,
- use UPPER
- if testing on substrings: use CONTAINING
- use a case-insensitive collation
(have a look at www.brookstonesystems.com)
Greetings,
Paul Vinkenoog
> How to ignore the case in queries.In general:
- use UPPER
- if testing on substrings: use CONTAINING
- use a case-insensitive collation
(have a look at www.brookstonesystems.com)
Greetings,
Paul Vinkenoog