實例分析Sybase數據庫Varchar類型的排序

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>