1> Select * from idid Order by 12> Go ID ---- 1 10 11 2 20
(5 rows affected) 1> Select * from IDID ORDER by Convert (Integer, ID) 2> Go ID ---- 1 2 10 11 20
(5 rows affected) 1>