# Comparison Functions and Operators

```{toctree}
:maxdepth: 1
:titlesonly:

Comparison Functions and Operators Overview <comparison-functions-and-operators-overview>
> <greater-than>
>= <greater-than-or-equal>
< <less-than>
<>,!= <not-equal>
<= <less-than-or-equal>
= <assign-equal>
BETWEEN ... AND ... <between>
IN <in>
IS <is>
IS NOT <is-not>
IS NOT NULL <is-not-null>
IS NULL <is-null>
ISNULL <function_isnull>
ILIKE <ilike>
LIKE <like>
NOT BETWEEN ... AND ... <not-between>
NOT IN <not-in>
NOT LIKE <not-like>
COALESCE <coalesce>
```