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

[ChinaXtHuLang]

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

[chuifengde]

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

[快溜]

Select Replace(@str,',213','')

[newtee]

Replace(@str,'213,','')

[ChinaXtHuLang]

回复3楼的各位。。我也知道这么写。但是如果我的那个字段里面只有一个：213呢？

[快溜]

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

[ChinaXtHuLang]

引用 5 楼 ssp2009 的回复:

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

谢谢。。