字段类型 varchar
字段值
AL1
AL28
AL3
AL41
AL5
AL33
AL66
AL100
AL376
想让字段值按从小到大排序
AL1
AL3
AL5
AL28
AL33
AL41
AL66
AL100
AL376
select * from table where 1=1 order by Specimen+0
select * from table where 1=1 order by Specimen*1
CAST和CONVERT
都试过,实现不了,请高手支个招。
字段值
AL1
AL28
AL3
AL41
AL5
AL33
AL66
AL100
AL376
想让字段值按从小到大排序
AL1
AL3
AL5
AL28
AL33
AL41
AL66
AL100
AL376
select * from table where 1=1 order by Specimen+0
select * from table where 1=1 order by Specimen*1
CAST和CONVERT
都试过,实现不了,请高手支个招。
select * from table where 1=1 order by replace(Specimen,"AL","0")+ 0