Replace替换问题。帮忙看下吧。

Question

DECLARE @str VarChar(1000)
Set @str = '1,11,222,213,211,2341,342,34531'
Select Replace(@str,'213','')
-- 得到结果是：
1,11,222,,211,2341,342,34531
-- 我要的结果是：
1,11,222,211,2341,342,34531就是替换后。多了个：逗号。怕高手看不出来：
222,,211
222,211

Answer 1

DECLARE @str VarChar(1000)
Set @str = '1,11,222,213,211,2341,342,34531,'
Select Replace(@str,'213,','')

Answer 2

DECLARE @str VarChar(1000)
Set @str = '1,11,222,213,211,2341,342,34531'
Select stuff(Replace(','+@str,',213',''),1,1,'')