REPLACE

Replaces all occurrences of the <pattern> substring within the <expression> with the <replacement> substring.

Syntax

REPLACE (<expression>, <pattern, <replacement>)

Parameters

Parameter	Description	Supported input types
<expression>	The original string that will be searched for instances of the <pattern>.	TEXT
<pattern>	The substring to be searched and replaced in the string.	TEXT
<replacement>	The substring to replace the original substring defined by <pattern>. To remove the <pattern> substring with no replacement, you can use a empty string '' as the replacement value.	TEXT

Example

In the example below, “two” in “Level two” is replaced with “three”.

SELECT
	REPLACE('Level two','two','three') AS level; 

Returns: Level three

In this example below, “eight” is replaced by an empty string.

SELECT
	REPLACE('Level eight',' eight','') AS level;

Returns: Level

In this following example, the substring “five” is not found in the original string, so the string is returned unchanged.

SELECT
	REPLACE('Level four','five','six') AS level;

Returns: Level four