Subject Re: [firebird-support] Case insensitive queries in Firebird 3 ?
Author Thomas Steinmaurer
> will there be case insensitive queries that can use an index in Firebird 3 ?
> I often see questions about this issue in this newsgroup and now i want
> to know if this problem will be adressed in the next future ?
> I think it would be a very useful feature.

In Firebird 2, there will be expression indices available.

For example, you can create an index like that:

create index idx_customer_fullname_ci on customer computed by

The following query will use the index then:

select * from customer where upper(fullname) = upper('Sparky');

Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions