how to use replace function in sql server

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