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

Syntax

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

Parameters

ParameterDescriptionSupported 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