create table #t(
id int identity(1,1),
a varchar(50)
)
insert into #t select '10abc'
insert into #t select '10aadbc'
insert into #t select '130fdabc'
insert into #t select '10aadbc'
insert into #t select '20abfac'
insert into #t select '10abc'
--先看看原始数据
select * from #t
--修改
update #t set a=case when left(a,2)='10' then left(a,2)+'[string]'+substring(a,3,len(a)-2) else a end
--新的结果
select * from #t