what happens when the field you order by on

is null

for many records

for example :

select top 10 custnum,custname from customers where custname >

(select max(custname)  from customers ) A order by custname

when you got many records where custname = null

then the result is null

resolve that please