替换字段中最后一个字符“，”为空

[wenhao676]

怎么写这个sql语句？

[青锋-SS]

update tb set col=left(col,len(col)-1) where charindex('，',col)>0

[liangCK]

declare @str varchar(20)
set @str='adf,eafd,ad,f'
set @str=reverse(stuff(reverse(@str),charindex(',',reverse(@str)),1,''))
select @str

[wenhao676]

谢谢

[青锋-SS]

--上面是更新的,这个是选择的
select left(col,len(col)-1) as col from tb where charindex('，',col)> 0

[kk19840210]

declare @str varchar(100)
select @str='adc,def,xy,sss'
select stuff(@str,len(@str)-charindex(',',REVERSE(@str))+1,1,'')

adc,def,xysss

declare @str varchar(100)
select @str='adc,def,xy,sss,'
select stuff(@str,len(@str)-charindex(',',REVERSE(@str))+1,1,'')

adc,def,xy,sss

[Andy-W]

try:

CREATE TABLE #T(x nvarchar(50))
INSERT INTO #T
SELECT 'xcvdsx,sdfdsa,osou,ds,sdfw' UNION ALL
SELECT 'xcvdsx,33,sd,sdfw' UNION ALL
SELECT 'cxc'
SELECT * FROM #T
DECLARE @X nvarchar(50)
DECLARE @i int

UPDATE #T SET @X=REVERSE(x),@i=CHARINDEX(',',@X),@X=CASE @i WHEN 0 THEN @x ELSE SUBSTRING(@x,1,@i-1)+' '+RIGHT(@x,LEN(@x)-@i) END
,x=REVERSE(@X)
SELECT * FROM #T

DROP TABLE #T