update SMSBilling_MTv2 set area=unicomseg.Province from SMSBilling_MTv2,unicomseg
where SMSBilling_MTv2.tomobilenumber>=(convert(varchar,unicomseg.StartNum)+'0000')
and SMSBilling_MTv2.tomobilenumber<=(convert(varchar,unicomseg.EndNum)+'9999')
二、
update SMSBilling_MTv2 set area=unicomseg.Province from SMSBilling_MTv2,unicomseg
where SubString(SMSBilling_MTv2.tomobilenumber,1,7) between unicomseg.StartNum and unicomseg.EndNum
update SMSBilling_MTv2 set area=unicomseg.Province from SMSBilling_MTv2,unicomseg
where SMSBilling_MTv2.tomobilenumber>=unicomseg.(convert(varchar,StartNum)+'0000')
and SMSBilling_MTv2.tomobilenumber<=unicomseg.(convert(varchar,EndNum)+'9999')