DECLARE @STR NVARCHAR(200) SET @STR='466,468,469,471,473,,,,,,,641,,,9,,,759,768,,,,,834,,839,'WHILE CHARINDEX(',,',@STR)>1 BEGIN SELECT @STR=REPLACE(@STR,',,',',') ENDSELECT @STR SELECT LEFT(@STR,LEN(@STR)-1)
replace(字段 , ',,' , ',') 一直做下去,直到结束.
DECLARE @STR NVARCHAR(200) SET @STR='466,468,469,471,473,,,,,,,641,,,9,,,759,768,,,,,834,,839,'WHILE CHARINDEX(',,',@STR)>1 BEGIN SELECT @STR=REPLACE(@STR,',,',',') ENDSELECT @STR SELECT LEFT(@STR,LEN(@STR)-1)正确
replace(字段 , ',,' , ',')
谢谢..好了.就 UPDATE TB SET COL = replace(COL, ',,', ',') UPDATE TB SET COL= replace(COL, ',,,', ',') UPDATE TB SET COL = replace(COL, ',,,,', ',') UPDATE TB SET COL = replace(COL, ',,,,,', ',') 反复几遍就OK了....
SET @STR='466,468,469,471,473,,,,,,,641,,,9,,,759,768,,,,,834,,839,'WHILE CHARINDEX(',,',@STR)>1
BEGIN
SELECT @STR=REPLACE(@STR,',,',',')
ENDSELECT @STR
SELECT LEFT(@STR,LEN(@STR)-1)
一直做下去,直到结束.
SET @STR='466,468,469,471,473,,,,,,,641,,,9,,,759,768,,,,,834,,839,'WHILE CHARINDEX(',,',@STR)>1
BEGIN
SELECT @STR=REPLACE(@STR,',,',',')
ENDSELECT @STR
SELECT LEFT(@STR,LEN(@STR)-1)正确
UPDATE TB
SET COL = replace(COL, ',,', ',')
UPDATE TB
SET COL= replace(COL, ',,,', ',')
UPDATE TB
SET COL = replace(COL, ',,,,', ',')
UPDATE TB
SET COL = replace(COL, ',,,,,', ',')
反复几遍就OK了....