内容参考:http://blog.csdn.net/kemy88/archive/ 特此感谢
在实际操作时发现使用字符型的数值进行排序输出时出现了,2排在所有第一个字符为1的数字的后面
sql如下:
SELECT DISTINCT WEEK from bk_cmsindex WHERE Termid=" & termid & " order by week
怎么办内,方法就是按照数字型字段*1或+0让其变成数值型
SELECT DISTINCT WEEK from bk_cmsindex WHERE Termid=" & termid & " order by week*1
或
SELECT DISTINCT WEEK from bk_cmsindex WHERE Termid=" & termid & " order by week+0