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
