SELECT TRIM (TRAILING '"' FROM Category)--, TRIM (LEADING '"' FROM Category) FROM Content

UPDATE Content SET Category = TRIM (TRAILING '"' FROM Category)

UPDATE Content SET Category = TRIM (LEADING '"' FROM Category)

Here CATEGORY is the column name, and CONTENT is the table