create function dele(
@a varchar(50)
)returns varchar(50)
as
begin
declare @b varchar(50)
set @b=@a+','
if charindex('''a'',',@b)<>0
set @b= replace(@b,'''a'',','')
if charindex('''b'',',@b)<>0
set @b= replace(@b,'''b'',','')
if charindex('''c'',',@b)<>0
set @b= replace(@b,'''c'',','')
set @b=left(@b,len(@b)-1)
return (@b)
end
Declare @ss varchar(4000)
update TALBE set
test=case when Left(@ss,1)=',' then stuff(@ss,1,1,'') else @ss end,
@ss=replace(replace(replace(','+test,',''a''',''),',''b''',''),',''c''','')