把varchar转换为int 然后进行排序

select * from yourtable order by cast(yourcol as int);