Comma to filter out all data in a column

skipper

A table in the database, the data stored in a column is 1, 2, 3, how to change all data in the column to 123

cv4bf5d65fd

select replace ('1, 2, 3', ',', '')

我是杀人狂

select repalce ('1,2,3 ,,', ',', '')

cv4bf5d65fd

--Inquire
select replace (column_name, ',', '') from tablename
--Update
update tablename set column_name = replace (column_name, ',', '')

hiqwolfzzh

Note whether it is Chinese comma or English.

select replace ('1, 2, 3', ',', '') from table


update table set column = replace (column, ',', '')

恶魔右指

Just replace this function

恶魔右指

-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)

chyg2008

- 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)
——————————————————————
fart! ! ! Of course, it must be divided into half-width! ! ! What is your SQL? So powerful?

wgfxman

select replace(replace('1,2,3,4',',',''),',','')

恶魔右指

to:chyg2008

Don’t talk like that

The above is the test result will not look at home to eat shit