> ## Documentation Index
> Fetch the complete documentation index at: https://firebolt-aggregate-helm-docs-pr-97.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Regular expressions functions

> Snowflake regular expressions functions supported in Snowflake compatibility mode.

<span className="feature-tag">Preview</span>

Snowflake [regular expressions functions](https://docs.snowflake.com/en/sql-reference/intro-summary-operators-functions) in [Snowflake compatibility mode](/reference-sql/snowflake/overview).

| Function             | Support          | Notes                                                                                                                                                                                              |
| :------------------- | :--------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `REGEXP_COUNT`       | Supported        |                                                                                                                                                                                                    |
| `REGEXP_EXTRACT_ALL` | Supported        |                                                                                                                                                                                                    |
| `REGEXP_LIKE`        | Supported        |                                                                                                                                                                                                    |
| `REGEXP_REPLACE`     | Supported        | Replaces every match, as Snowflake does. With no replacement the matches are removed.                                                                                                              |
| `RLIKE`              | Supported        |                                                                                                                                                                                                    |
| `REGEXP_SUBSTR`      | With limitations | The two-argument form only. Snowflake's later arguments are a start position, an occurrence and parameters, which mean something else here, so a longer call is refused rather than mistranslated. |
| `REGEXP_SUBSTR_ALL`  | With limitations | The two-argument form only, as above.                                                                                                                                                              |
| `REGEXP_INSTR`       | Not supported    | The position of a match needs the subject twice, once to match and once to locate, and the translation cannot duplicate an expression without evaluating it twice.                                 |
| `REGEXP`             | Not supported    |                                                                                                                                                                                                    |