Hi,
If you bother about the NULLs positioned at the bottom of the selection,
and not how
non-NULL data is ordered, you can just use ORDER BY field DESC - this will
position
NULLs at the bottom, ordering non-NULL data from the highest values to the
lowest.
Regards,
Stoyan Genov
> Hi,
>
> how can I force NULL rows at the bottom of the result list in an
> ordered SELECT?
>
> with ORDER BY I get
>
> NULL
> Peter
> Jane
>
> but I want
>
> Peter
> Jane
> NULL
>
> --
> Dirk
>
> ************
>