Delete quotes on all rows in a column

Question

I have a column in a table that has values ​​enclosed in quotation marks (for example, "USA", "Mexico", "Russia", "China", etc.). I would like to remove the quotes and leave the rest (USA, Mexico, etc.). Is there a simple statement for this? Or do I need to use a combination of the LEFT, RIGHT, and SUBSTRING functions? thanks in advance

Answer 1

This will delete all marks, even those that are in the middle of the value.

 UPDATE YourTable SET CountryName = REPLACE(CountryName, '"', ''); 

Answer 2

Well, if you want to get rid of all double quotes, how about:

 SELECT REPLACE(countryColumn, '"', '') AS countryColumn FROM theTable 

Or a similar update if you really want to change the data.