SQL Statement

Fastest way to replace a table field string with SQL statement. UPDATE [THETABLENAME] SET [THEFIELDNAME] = REPLACE(THEFIELDNAME, 'string_to_replace', 'new_string')