那你就测试一下len(car_number)数据是多少看看 declare @sql int select @sql=len(car_number) from insert_file print @sql
helloyou0的回答非常正确!真的只是length的问题!正确的写法就是结合xiaolei1982和helloyou0说的,且为substr而不是substring。 select * from insert_file order by right(car_numbe,1),substr(car_numbe,0,length(car_numbe)-1)
问题在于substring(car_numbe,0,len(car_numbe)-1)!请问应该怎么改呢?
try~~~
declare @sql int
select @sql=len(car_number) from insert_file
print @sql
select * from insert_file order by right(car_numbe,1),substr(car_numbe,0,length(car_numbe)-1)