如何对公交车次(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