SQL Find and Replace part of text

Want to update (find and replace) part of a text using SQl? Check out this query: UPDATE TABLE my_table REPLACE(my_column,'string_toreplace','new_string');