1> select * from idid order by 1
2> 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>
1> select * from idid order by 1
2> 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>