Removing a " from a varchar string stored in a table

[cheland]

replace(column1,'"') (double quote inside single quotes)

This will eliminate all " inside the string