>I've create an ascending index on a column that contains a .NULL. value. The records containing the .NULL. are at the top of the record set with the ascending values starting after the last .NULL. record. I would like ALL of the .NULL. records to be after the last ascending value (see sample below). Is there a way to have the .NULL. records at the bottom?
>
>
>Name Rank
>Robert 1
>Bill 2
>Mary 3
>Tom 4
>Linda .NULL.
>Sam .NULL.
>
>
>Actually, I'm changing the .NULL. indicator to 'No Rank' using SET NULLDISPLAY TO 'No Rank' but this doesn't change the way the records are diplayed, as the 'No Rank' records still end up at the top of the list and I want them at the bottom.
>
>Thanks,
>Robert
INDEX ON -Rank DESC TAG ...