Update one field of all tuples in my database (MS SQL)

Question

Hi,

I've imported a country database from somewhere, with these fields:

Abbr varchar(2), FullName varchar(50)

An example tuple is:

AL, "Albania"

As you can see, the data in the second field is surrounded by quotation marks. I'd like to remove them, because they make the rest of my code just a little more annoying (I have to remove them programmatically each time).

Is there a microsoft sql server (2008) Update statement I can run to remove the quotation marks?

Answer 1

UPDATE MyTable
SET FullName = Replace(FullName, '"', '')