At 07:56 AM 12/10/2000 -0500, Doug Chamberlin wrote:

>I think you could make a case for having NULLs always trail the non-NULL
>values in a result set, regardless of the requested sort order of the
>result set. While I can see the logic of thinking of NULL as a value which
>has a collation order, I can also see the logic of treating them as "and we
>also have these records which were produced but they don't quite fit in so
>we are sending them along at the end".

Logic has little to do with SQL and where Firebird uses standard SQL syntax,
we should use standard SQL semantics. Extensions are another issue.

Regards,

Ann
www.ibphoenix.com
We have answers.