REPLACE - Firebolt Documentation

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

Syntax

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

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`

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

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

level text
Level three

Rows: 1Execution time: 5.75ms

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

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

level text
Level

Rows: 1Execution time: 5.54ms

In this 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;

level text
Level four

Rows: 1Execution time: 5.20ms

⌘I