1、字符串前面和后面都有逗号
2、方法如下
3、SQL代码
select interest,
REPLACE(RTRIM(REPLACE(interest,',',' ')),' ',',') as '去掉字符串后面逗号',
stuff(interest,1,PATINDEX('%[^,]%',interest)-1,'') as '去掉字符串前面逗号',
REPLACE(RTRIM(REPLACE(stuff(interest,1,PATINDEX('%[^,]%',interest)-1,''),',',' ')),' ',',') as '去掉字符串前后所有的逗号'
from Class where id=1