any idea how to search for a " in a varchar column and get rid of it?
Printable View
any idea how to search for a " in a varchar column and get rid of it?
select replace('123"456', '"', '') from dual
replace(column1,'"') (double quote inside single quotes)
This will eliminate all " inside the string
I personally prefer this method
replace(column1,Chr(34))
Ie. Chr(34) stands for "