replace statement in sql

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