Posted by ActiveX on 01/25/06 22:22

I have a results set that is sorted on LineNum. Not all items have a
LineNum (some are null). I want my result set to return all items in
ASC LineNum order and then list all items with NULL LineNum at the end
of the results. Any Suggestions?

Thanks.

• Next in forum: Insert/Update with dynamic database name
• Prev in forum: Re: Can i debug/watch on the trigger's INSERTED and DELETED records/values?
• Thread view: ASC Result Set with Nulls at the bottom

[Reply to this message]