#replace a bad character with somethine else you want UPDATE myTable SET myColumn = REPLACE(myColumn, "'", "'")