电话号码长位操作:
--------------------------------------------------
电话号码变化:
是8位不变
否则 首字母2 前面加2
否则 加8
--------------------------------------------------
是8位不变
否则 首字母2 前面加2
否则 加8
--------------------------------------------------
update Tel_cybh
set number='2'+ number
where len(number)=7 and substring(number,1,1)=2
go
update Tel_cybh
set number='8'+ number
where len(number)=7 and substring(number,1,1)<>2
set number='2'+ number
where len(number)=7 and substring(number,1,1)=2
go
update Tel_cybh
set number='8'+ number
where len(number)=7 and substring(number,1,1)<>2