have u tried
1 nulls last, 2 nulls last, 3 nulls last?

On 3/10/10, jasajona <jon@...> wrote:
> 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!
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
Sent from my mobile device

regards
Alan McDonald