> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for REPLACE function

# REPLACE

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

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
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".

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	REPLACE('Level two','two','three') AS level; 
```

**Returns**: `Level three`

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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
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.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	REPLACE('Level four','five','six') AS level;
```

**Returns**: `Level four`