On Tue, 30 Aug 2011 12:20:56 +0400, Vander Clock Stephane
<svanderclock@...> wrote:

> Hello,
>
> how to put the num value at the end of the result (and not at the
> beginning) when we are doing
>
> select xxx order by xxx ASC

Something like:
ORDER BY field ASC NULLS LAST

See also section Sorts in
http://www.firebirdsql.org/pdfmanual/Firebird-Null-Guide.pdf