select substring(号码,1,2)+'6688'+substring(号码,4,号码长度-3)
from 表
where substring(号码,3,1)='8'
union
select substring(号码,1,2)+'6688'+substring(号码,4,号码长度-3)
from 表
where substring(号码,3,1)='9'
union
select substring(号码,1,3)+'6688'+substring(号码,5,号码长度-3)
from 表
where substring(号码,4,1)='9‘
from 表
where substring(号码,3,1)='8'
union
select substring(号码,1,2)+'6688'+substring(号码,4,号码长度-3)
from 表
where substring(号码,3,1)='9'
union
select substring(号码,1,3)+'6688'+substring(号码,5,号码长度-3)
from 表
where substring(号码,4,1)='9‘
select substring(号码,1,2)+'6688'+substring(号码,4,Len(号码)-3)
from 表
where substring(号码,3,1)='8'
union
select substring(号码,1,2)+'6688'+substring(号码,4,Len(号码)-3)
from 表
where substring(号码,3,1)='9'
union
select substring(号码,1,3)+'6688'+substring(号码,5,Len(号码)-4)
from 表
where substring(号码,4,1)='9'
union
select 号码
from 表
where substring(号码,4,1)<> '9'
or substring(号码,3,1) = '8'
or substring(号码,3,1) = '9'
from 表
where substring(号码,3,1)='8'
union
select 号码,substring(号码,1,2)+'6688'+substring(号码,4,Len(号码)-3) as 新号码
from 表
where substring(号码,3,1)='9' and substring(号码,3,1)<>'8'
union
select 号码,substring(号码,1,3)+'6688'+substring(号码,5,Len(号码)-4) as 新号码
from 表
where substring(号码,4,1)='9' and substring(号码,3,1)<>'9' and substring(号码,3,1)<>'8'