实例分析Sybase数据库Varchar类型的排序

核心提示：本文主要介绍了Sybase数据库Varchar类型的排序示例，具体内容请参考下文：1> select * from idid order by 12> goid11011220(5 rows affected)1> select * from idid order by convert(integer

本文主要介绍了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>