How to remove characters?

Database
Enthusiast

How to remove characters?

Hi All,

I have a column of data that contains double quotes around the data (ex: "1234") - anyone know how to remove the quotes with an easy SQL statement?

TIA,

myk
3 REPLIES
Senior Apprentice

Re: How to remove characters?

Hi myk,
trim(both '"' from col)
Enthusiast

Re: How to remove characters?

Bravissimo!

Grazie grazie grazie!
Fan

Re: How to remove characters?

Any Way to replace the Single Quotes with Double quotes.

I am getting error while passing single quotes values as parameter in stored procedure. I need to handle these errors inside the procedure itself instead of passing it as double quotes values.