>>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?
No, but it's better to be by the field name or alias name for the field. Take a look again at the referenced blog - it explains the problem very nicely.
If it's not broken, fix it until it is.
My Blog