> 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
(upper(fullname));


The following query will use the index then:

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



--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com