Removing a " from a varchar string stored in a table

[rgaskell]

any idea how to search for a " in a varchar column and get rid of it?

[m1l]

select replace('123"456', '"', '') from dual

[cheland]

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

This will eliminate all " inside the string

[salamander]

I personally prefer this method
replace(column1,Chr(34))

Ie. Chr(34) stands for "