>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

On top of my head.

INDEX ON NVL(Rank,9999999) TAG ....