sql 字符串处理问题 来者有分

@s='S1,S2,S12,S23';

将@s里面的S1,S2替换成处理，未处理

---

来者有分.

---

REPLACE(@s,'S1,S2','处理,未处理')

---

REPLACE 不好用 自己试下

---

SQL code:

declare @s varchar(200)
set @s='S1,S2,S12,S23'
select replace(@s,'S1,S2','处理,未处理')

---

大家这样试下
@s='S1,S12,S2,S23';

将@s里面的S1,S2替换成处理，未处理

---

SQL code:
declare @s varchar(200)
set @s='S1,S12,S2,S23'
set @s = ',' + @s +','
set @s = replace(@s, ',S1,',',处理,')
set @s = replace(@s, ',S2,',',未处理,')
select substring(@s, 2, len(@s) - 2)
/*
处理,S12,未处理,S23
*/

---

SQL code:
DECLARE @s varchar(MAX);
SET @s = 'S1,S12,S2,S23,S1';

SELECT @s = REPLACE(REPLACE(','+@s+',',',S1,',',处理,'),',S2,',',未处理,')

SELECT STUFF(LEFT(@s,LEN(@s)-1),1,1,'')

---

SQL code:
declare @s varchar(200)
set @s='S1,S12,S2,S23'
set @s = ',' + @s +','
set @s = replace(replace(@s, ',S1,',',处理,'),',S2,',',未处理,')
select su