替朋友問一下小問題。字符串替換。。。

Question

select replace(replace (a,b+',',''),b,'')

Answer 1

關鍵可能﹕
a='一二三,123﹐abc,123'或
a='一二三,123﹐abc' 或
a='123﹐abc'
結果是要去掉'123'

Answer 2

declare @a varchar(50),@b varchar(10)
select @a='一二三,123,abc,123'
,@b='123'select replace(replace(replace(@a,','+@b+',',','),','+@b,''),@b+',','')/*--结果
                                                                                                                                                                                                                                                                 
-----------------
一二三,abc
--*/

Answer 3

declare @b varchar(10)
select @b='123'select replace(replace(replace(a,','+@b+',',','),','+@b,''),@b+',','')
from(
select a='一二三,123﹐abc,123'
union all select '一二三,123﹐abc'
union all select '123,abc'
) a/*--结果
                                                                                                                                                                                                                                                                 
---------------
一二三﹐abc
一二三﹐abc
abc（所影响的行数为 3 行）
--*/