Home Forums Programming General Sorting of 2 columns RE: Sorting of 2 columns
Calvin Lawson
SSChampion
Points: 11030
More actions
June 27, 2003 at 11:50 am
#463523
Actually, to produce the results:
6 4
6 2
3 7
2 3
You actually want to sort by:
64
62
37
23
so:
Select * from Table
order by cast(col1 as varchar) + cast(col2 as varchar) Desc
Signature is NULL