select firstName+lastName as fullName,firstName,lastName from myTable order by fullName>
select firstName+lastName as fullName,firstName,lastName from myTable order by 1I'm not sure these two work in SQL Server. I don't have SQL Server installed right now to verify this.
select firstName,lastName from myTable order by firstName+lastName>
select newId(),* from mytable order by 1>
select * from mytable order by newID()>