sql server replace function

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