> ## 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.

# Conditional expression functions

> Snowflake conditional expression functions supported in Snowflake compatibility mode.

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

Snowflake [conditional expression functions](https://docs.snowflake.com/en/sql-reference/expressions-conditional) in [Snowflake compatibility mode](/reference-sql/snowflake/overview).

| Function                                                            | Support          | Notes                                                                                                                                      |
| :------------------------------------------------------------------ | :--------------- | :----------------------------------------------------------------------------------------------------------------------------------------- |
| `COALESCE`                                                          | Supported        |                                                                                                                                            |
| `EQUAL_NULL`                                                        | Supported        | Two NULLs compare equal, as in Snowflake.                                                                                                  |
| `GREATEST_IGNORE_NULLS`                                             | Supported        |                                                                                                                                            |
| `GREATEST`                                                          | With limitations | A NULL argument is skipped and a value returned, where Snowflake answers NULL. Use `GREATEST_IGNORE_NULLS` when skipping is what you want. |
| `IFF`                                                               | Supported        |                                                                                                                                            |
| `IFNULL`                                                            | Supported        |                                                                                                                                            |
| `LEAST_IGNORE_NULLS`                                                | Supported        |                                                                                                                                            |
| `LEAST`                                                             | With limitations | A NULL argument is skipped, as with `GREATEST` above.                                                                                      |
| `NOT`                                                               | Supported        |                                                                                                                                            |
| `NULLIFZERO`                                                        | Supported        |                                                                                                                                            |
| `NULLIF`                                                            | Supported        |                                                                                                                                            |
| `NVL2`                                                              | Supported        |                                                                                                                                            |
| `NVL`                                                               | Supported        |                                                                                                                                            |
| `ZEROIFNULL`                                                        | Supported        |                                                                                                                                            |
| `DECODE`                                                            | With limitations | Available for some argument types only.                                                                                                    |
| `BOOLAND`, `BOOLNOT`, `BOOLOR`, `BOOLXOR`, `REGR_VALX`, `REGR_VALY` | Not supported    |                                                                                                                                            |