You will kick yourself when you see how to do a case insensitive order
by. You do not need to include every field in the order by in your select.

select id, name
from Human
order by Upper(name)

should work on Firebird 1.5

--- In firebird-support@yahoogroups.com, "Anton Malinovskiy"
<anton@a...> wrote:

> Hello everybody,
>
>
>
> I've found that select statements like:
>
>
>
> select id, name
>
> from Human
>
> order by name;
>
>
>
> are case sensitive and the only way for case insensitive "order by"

which

> I've found is select statement like:
>
>
>
> select id, name, upper(name)
>
> from Human
>
> order by 3;
>
>
>
> But this solution doesn't suit me. Is the any other solution?
>
>
>
> Thank you in advance.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]