Search & Replace SQL Characters

Here is how to replace m-dash characters with a dash character:

UPDATE Customer
SET CompanyName= REPLACE(CompanyName,CHAR(150),CHAR(45))
WHERE CompanyName Like '%' + CHAR(150) + '%'