| Subject | Case insensitive indexes |
|---|---|
| Author | Asbjorn Heggvik |
| Post date | 2002-09-04T09:07:25Z |
Is there a posibility to make indexes case insensitive in firebird, or will
it be in the nest version.
I over and over again need to make queries like this in large name datebases
in fields like LastName, FirstName, Address and so further.
If I make a Query like this: SELECT ... WHERE UPPER(LASTNAME) LIKE 'JOHN%'
,
my Index will be of no use and my Query will be to slow.
Asbjorn
it be in the nest version.
I over and over again need to make queries like this in large name datebases
in fields like LastName, FirstName, Address and so further.
If I make a Query like this: SELECT ... WHERE UPPER(LASTNAME) LIKE 'JOHN%'
,
my Index will be of no use and my Query will be to slow.
Asbjorn