Subject Case insensitive indexes
Author Asbjorn Heggvik
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.