Hello Ismael!

>
> select * from (select "TESTID", "NAME" from test
> union select "TESTID", "NAME" from test) t order by upper(2)
>

The query is indeed accepted by Firebird, but the sorting result is wrong as for a single select (as found out later).