If sql server was ignoring the case, then you are doing nothing to the sort order by making everything uppercase.
Sql server viewed everything at the same level whether you uppercase everything or not. UPPPER basically didn't do anything to the sort order.
Live to Throw
Throw to Live
Will Summers