SQL REPLACE Function
Example Replace “T” with “M”: SELECT REPLACE(‘SQL Tutorial’, ‘T’, ‘M’); Definition and Usage The REPLACE() function replaces all occurrences of a substring within a string, with a new substring. Note: The search is case-insensitive. Tip: Also look at the STUFF()…