Replace table string with SQL Query

Fastest way to replace a table field string with SQL statement.

UPDATE [THETABLENAME]
SET [THEFIELDNAME] = REPLACE(THEFIELDNAME, 'string_to_replace', 'new_string')