Update values in column

I have following SQL-Table:

A   B  C   D
"1" 2  3  "4" 
"2" 4  4  "5"
"4" 1  6  "9"

I would like to remove the “”

So my result should look like this:

A  B  C  D
1  2  3  4
2  4  4  5
4  1  6  9

Answer

It’s just a simple UPDATE with REPLACE() function as

UPDATE YourTable
SET A = REPLACE(A, '"', ''),
    B = REPLACE(B, '"', ''),
    C = REPLACE(C, '"', ''),
    D = REPLACE(D, '"', '')
--Where conditions if needed