Using SQL to Replace Smart Quotes and Other Special Characters

UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '’', '''')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '–', '--')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '“', '"')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '”', '"')
UPDATE [table_name] SET [column_name] = REPLACE( [column_name], '…', '...')