> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8c05c8a2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Documentation describing the APPLY modifier which allows you to invoke some function for each row returned by an outer table expression of a query.

# Replace modifier

> Allows you to specify one or more [expression aliases](/reference/syntax#expression-aliases).

Each alias must match a column name from the `SELECT *` statement. In the output column list, the column that matches
the alias is replaced by the expression in that `REPLACE`.

This modifier does not change the names or order of columns. However, it can change the value and the value type.

**Syntax:**

```sql theme={null}
SELECT <expr> REPLACE( <expr> AS col_name) from [db.]table_name
```

**Example:**

```sql theme={null}
SELECT * REPLACE(i + 1 AS i) from columns_transformers;
```

```response theme={null}
┌───i─┬──j─┬───k─┐
│ 101 │ 10 │ 324 │
│ 121 │  8 │  23 │
└─────┴────┴─────┘
```