对于varchar型数据直接排序排序会出现以下问题
1、转化成int
select 卡号,姓名,部门,当前区域 from v_Personnel_InWell where 入井时间 is not null order by convert(int,卡号)
select * from SMS_Customer where vc_Name not like '%假%' and vc_Name not like '%调休%' order by right( '00000000000000000000' + vc_ID,20)