How to replace substring in given string!!

Do it like this:-
THIS is to show how a string can be replaced by new text in the column.

UPDATE TABLE_NAME
SET COLUMN_NAME = REPLACE(COLUMN_NAME,'OLDTEXT','NEWTEXT')