SQL Replace function with example

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