how to replace string in sql server

SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .