--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

> I would take another approach.
>
> I would use a case insensitive collation. I use collation PT_BR on
> charset ISO8859_1.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>

I can double this. Usage of a case insensitive collation (appropriate
for your character set) is much better approach. Such collation helps
you to avoid expression indexes for this purpose and will free your
hands by writing select statements with Order By clause.
The optimizer needs to write full index expression in the Order By to
recognize availability of the index for your select statement at all.

Hope you find such collation for your character set.

Boro