如何对公交车次(1,2,3,11,20,K3,K4,T5,T6)排序呢？ 数字和字符串均按照从小到大！
如何对公交车次(1,2,3,11,20,K3,K4,T5,T6)排序呢？ 数字和字符串均按照从小到大！

[解决办法]
SELECT COL FROM TABLE WHERE ISNUMERIC (COL)=TRUE ORDER BY COL UNION ALL
SELECT COL FROM TABLE WHERE ISNUMERIC (COL)=FALSE
[解决办法]
select * from ... order by 公交车名
[解决办法]
SELECT COL FROM TABLE WHERE ISNUMERIC (COL)=TRUE ORDER BY COL UNION ALL
SELECT COL FROM TABLE WHERE ISNUMERIC (COL)=FALSE ORDER BY COL