Hi,

You can define NULLs placement by column.
In example:
ORDER BY 2 NULLS LAST, 1 NULLS LAST, 3 NULLS LAST

http://www.firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-tbl-null-placement

Gabor

jasajona írta:

> Hello,
>
> If there is: ORDER BY 2 NULLS LAST
> Everything is fine all records with second field value NULL go to bottom.
>
> If there is: ORDER BY 2, 1, 3 NULLS LAST
> Even if all first three fields are null record go to top.
>
> Should I report a bug or there is something else that I do not know?
>
> Thank you!