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

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


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.