Create Table TEST(ID Int Identity(1,1),Name Varchar(50))
Insert TEST Select 'liu,jun,lyg'
Union All Select 'bb,aa'
Union All Select 'cc,dd,ee'
GO
Update TEST Set Name=Replace(Name,',',',KKK')
Select * From TEST
GO
Drop Table TEST
--Result
/*
ID Name
1 liu,KKKjun,KKKlyg
2 bb,KKKaa
3 cc,KKKdd,KKKee
*/
Insert TEST Select 'liu,jun,lyg'
Union All Select 'bb,aa'
Union All Select 'cc,dd,ee'
GO
Update TEST Set Name=Replace(Name,',',',KKK')
Select * From TEST
GO
Drop Table TEST
--Result
/*
ID Name
1 liu,KKKjun,KKKlyg
2 bb,KKKaa
3 cc,KKKdd,KKKee
*/
declare @t table(id int identity(1,1),name varchar(50))
insert @t select 'liu,jun,lyg'
select replace(name,',',',kkk') from @t
insert tests select 1,'aaa,bbb,ccc'
Union All Select 2,'xxx,vvv,y'select REPLACE(names,',',',kkk') from tests 结果为:
aaa,kkkbbb,kkkccc
xxx,kkkvvv,kkky