>In SQL server however all of these are valid:
>
>

select firstName+lastName as fullName,firstName,lastName from myTable order by fullName

>

select firstName+lastName as fullName,firstName,lastName from myTable order by 1

I'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

>
>In the same manner you could do:
>
>

select newId(),* from mytable order by 1

>
>or:
>
>

select * from mytable order by newID()

>
>Cetin