> what I mean is when you sort on a column and it has nulls in the it.
> Currently, they always are at the end. I thought in one of the
> candate releases they sorted to the begin or end depending on if you
> sorted that column desc or asc.

Since Firebird 1.5 Alpha 1:


* New NULL order handling.
Allow user-defined ordering of NULLs.
Syntax:
[ORDER BY <order_list>]
<order_list> = {col | int} [COLLATE collation]
[ASC[ENDING] | DESC[ENDING]] [NULLS {FIRST | LAST}]
[, <order_list> ...]
Note:
Default behaviour is NULLS LAST.
Contributor(s):
Nickolay Samofatov <skidder@...>



HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase/Firebird
http://www.iblogmanager.com