SQL Server REPLACE() Function

Posted by

SQL Server

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

Syntax

REPLACE(

string

,

old_string

,

new_string

)

Parameter Values

Parameter Description

string
Required. The original string

old_string
Required. The string to be replaced

new_string
Required. The new replacement string

Technical Details

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

More Examples

Example

Replace “SQL” with “HTML”:

SELECT REPLACE(‘SQL Tutorial’, ‘SQL’, ‘HTML’);

Example

Replace “a” with “c”:

SELECT REPLACE(‘ABC ABC ABC’, ‘a’, ‘c’);