>VFP order by the first field in descending order. Even then that is not really used (or better not used I think). I see it sometimes though. Perhaps he had VFP on his mind??? :o)
So, basically, ORDER BY in SQL Server should always be by reference and not by sequence, as supported in VFP. Is that correct?