这个UPDATE怎么写啊...

[gerrylc]

表:TALBE

test
'a','b','c','d','e','f'
'a','b','c','j','t','o'
'a','b','c','n','r','d'
'a','d','c'
'e','b','c','d','u','f'
'g','h','a','b','c','f'

将字段test中含有的'a'或'b'或'c'删除
注:要注意','的存在
谢了.....

[gerrylc]

不会吧,没人知道怎么写么......

[lw1a2]

update TALBE set test=stuff(test,charindex('''a'',''b'',''c''',test),12,'')

[WangZWang]

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''','')

[lsqkeke]

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

update 表名 set test=dbo.dele(test)

[gerrylc]

谢谢阿来兄,结帖...

[浩方软件HFWMS]

别急

[gerrylc]

To: lsp69(浪子神剑)
还有什么好方法么???