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

# Operators

> Snowflake operators supported in Snowflake compatibility mode.

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

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

## Supported operators

| Operator                                                                                 | Support   | Notes                                                              |
| :--------------------------------------------------------------------------------------- | :-------- | :----------------------------------------------------------------- |
| [Arithmetic](https://docs.snowflake.com/en/sql-reference/operators-arithmetic)           | Supported | `+`, `-`, `*`, `/`, `%`. See the note on integer division below.   |
| [Comparison](https://docs.snowflake.com/en/sql-reference/operators-comparison)           | Supported | `=`, `!=`, `<>`, `<`, `<=`, `>`, `>=`, `BETWEEN`, `IN`, `IS NULL`. |
| [Logical](https://docs.snowflake.com/en/sql-reference/operators-logical)                 | Supported | `AND`, `OR`, `NOT`.                                                |
| [`\|\|` concatenation](https://docs.snowflake.com/en/sql-reference/operators-arithmetic) | Supported | Also concatenates arrays.                                          |
| [`::` cast](https://docs.snowflake.com/en/sql-reference/operators-cast)                  | Supported | Equivalent to `CAST`.                                              |
| [`:` path](https://docs.snowflake.com/en/sql-reference/operators-subscript)              | Supported | Path access into a semi-structured column.                         |
| [`[]` subscript](https://docs.snowflake.com/en/sql-reference/operators-subscript)        | Supported | Array and object element access.                                   |
| [`LIKE`, `ILIKE`](https://docs.snowflake.com/en/sql-reference/functions/like)            | Supported | Including `LIKE ANY`.                                              |
| [`RLIKE`, `REGEXP`](https://docs.snowflake.com/en/sql-reference/functions/rlike)         | Supported |                                                                    |

## Limitations

Integer division differs from Snowflake and is the difference most likely to affect a real workload, because division is common and the result is plausible rather than obviously wrong:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT 1/2;
```

Returns `0`, where Snowflake returns `0.500000`. Snowflake has no integer division: `/` always produces a `NUMBER`. Any migrated query that divides two integers silently returns different numbers, and there is no diagnostic. Cast one operand to make the intent explicit:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT 1::FLOAT / 2;   -- 0.5 in both
```