> ## 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        |                                         |
| `GREATEST`                                                                                                                       | Supported        |                                         |
| `IFF`                                                                                                                            | Supported        |                                         |
| `IFNULL`                                                                                                                         | Supported        |                                         |
| `LEAST`                                                                                                                          | Supported        |                                         |
| `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`, `EQUAL_NULL`, `GREATEST_IGNORE_NULLS`, `LEAST_IGNORE_NULLS`, `REGR_VALX`, `REGR_VALY` | Not supported    |                                         |