在有字符的情况下，如何按照从小到大来排序？

[pdysuny]

我要这样来排序：A1-001，A1-002,A1-003....这样按照A1后面的数字从小到大来排序，查询该如何写呢？

[是是非非]

select * from ne_p where louc='一' order by CAST(SUBSTRING(puwei,3,LEN(puwei)-3) AS INT) ASC

[是是非非]

select * from ne_p where louc='一' order by CAST(RIGHT(puwei,LEN(puwei)-3) AS BIGINT) ASC

[无爱大叔]

select substring(puwei,4,10) as puwei from ne_p

[feng2112]

我说的 order by A1（表示的字段）就是order by puwei 我晕～～～

[feng2112]

sql="select * from ne_p where louc='一' order by puwei"
就可以了，何必那么麻烦

[feng2112]

order by A1（表示的字段）

[pdysuny]

sql="select * from ne_p where louc='一' order by A1(puwei) desc"

提示：Microsoft JET Database Engine 错误 '80040e14'

表达式中 'A1' 函数未定义。

/3ban/lcl1.asp，行 158

该怎么做呢？

[无爱大叔]

sql="select * from ne_p where louc='一' order by puwei desc"

[银狐被占用]

去掉desc

[tigerwen01]

sql="select * from ne_p where louc='一' order by puwei ASC"

[lisoon]

sql="select * from ne_p where louc='一' order by puwei ASC"
这样排的话A1-110000会排在A1-2000的前面。
我看要处理下才能排列。