Comma to filter out all data in a column

asurae

- Full-width half-width, all can be removed
declare @a varchar(10)
set @a='1, 2, 3,,'
select replace(@a,',','')
-------------------
123

(The number of rows affected is 1 row)
-------------------------------------------------
The test is completely correct. Full-width half-width can be removed.

恶魔右指

SQL default sorting is possible
create table ta(name varchar(10)collate Chinese_PRC_CS_AS_WS)--If this sorting method was specified when the table was created
insert ta
select '1, 2, 3,,,'
select replace(replace(name,',',''),',','') from ta--it needs to be removed twice

mydriver

Hahahaha, express excitement, ^_^.

michealhenry

Support恶魔右指

72次灌水被抓

Just replace, hehe