字段是数字的排序问题

[hnsongbiao]

表ylcnv

id num 00001 00002 00003
1 2223 32 22 11
2 323 44 12 44
3 23 3 3 2



select * from ylcnv order by [00003] desc

请问 有一字段是数字 这样排序怎么结果不正确呢？

[Justin-Liu]

排序结果是根据字符串排的好像

[--小F--]

要得到什么结果?

[--小F--]

select * from ylcnv order by cast([00003] as int)desc

[Justin-Liu]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code
select * from ylcnv order by cast([00003] as int)desc
[/Quote]

[Justin-Liu]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code
select * from ylcnv order by cast([00003] as int)desc
[/Quote]
我准备闲暇的时候在SQL区混混 补补基础