替换字段中某一个字

将‘林’替换成‘燕’

create table #blogUser(

username nvarchar(15),

password nvarchar(10) )

 

insert into #blogUser values('林林','123')

insert into #blogUser values('陈东林','123')

insert into #blogUser values('李林','123')

insert into #blogUser values('张东三','123')

insert into #blogUser values('张东东','123')

 

update #blogUser set username=case charindex('林',username) 

when 1 then '燕'+ substring(username,2,len(username))

else substring(username, 1, charindex('林',username)-1) + '燕' + substring(username, charindex('林',username)+1, len(username)-charindex('林',username))

end 

where username like '%林%'

 

select * from #blogUser

 

效果如下所示：

username password

燕林           123

陈东燕        123

李燕           123

张东三        123

张东东        123