OpenWritings.net

UPDATE tableName SET fieldname = REPLACE(fieldname, 'replace this string', 'with that string');
 
--Replace Smth with Smith
UPDATE Person SET lastname = REPLACE(lastname, 'Smth', 'Smith');