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