//字符类型排序
SELECT *
FROM JXD_WD_STATIONINFO
ORDER BY CAST(STATIONCODE AS INT)

SELECT *
FROM JXD_WD_STATIONINFO
ORDER BY CONVERT(int, STATIONCODE)