In 80 compatibility when you have alias for derived column that is same as column name, the prefix is ignored in the order by statement and the order is done on the derived column. In 90 it is not ignored and the order is done on the table column first

Check out "Alter Database Compatibility Level" in BOL. It has differences between 80, 90 and 100.