how to remove symbols form data in sql code example

Example: sql delete caracter list

UPDATE table_name
SET field_name = replace(field_name, 'X', 'Y');