SQL Server REPLACE() Function — SQL

Replace "T" with "M":

sql

  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() function.

text

  REPLACE(string, old_string, new_string)

Parameter	Description
string	Required. The original string
old_string	Required. The string to be replaced
new_string	Required. The new replacement string

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Replace "SQL" with "HTML":

sql

  SELECT REPLACE('SQL Tutorial', 'SQL', 'HTML');

Replace "a" with "c":

sql

  SELECT REPLACE('ABC ABC ABC', 'a', 'c');