Removing Double Quotes from column values

Question

Hi All,

I have a table Customers. in thich i have a column 'status' .

The colum status have values as below.

"A"

"A"

"A"

"U"

"U"

I want to update this whole column and remove the double quotes from the values. there is like 4 million rows.

can someone please let me know the SQL i can use to accomplish this.

Thanks in Advance.

Regards

Answer 1

DECLARE @bloodyDoubleQuotes TABLE (status CHAR(3))
INSERT INTO @bloodyDoubleQuotes (status)
VALUES  
('"A"'),('"B"'),('"C"'),('"D"'),('"E"'),('"F"'),('"G"')

UPDATE @bloodyDoubleQuotes
SET status = REPLACE(status,'"','')

SELECT * FROM @bloodyDoubleQuotes

Boom boom, pow!

Answer 2

Can you try the below code?

UPDATE tableA
SET status = REPLACE(status,'"','')
where status like '%"%'

--Prashanth