# **Compare functions and operator overview**

| Name | Description |
|---|----|
| [>](greater-than.md) | greater than |
| [>=](greater-than-or-equal.md) | greater than or equal to |
| [<](less-than.md) | Less than |
| [<>,!=](not-equal.md) | Not equal |
| [<=](less-than-or-equal.md) | Less than or equal to |
| [=](assign-equal.md) | equals |
| [BETWEEN ... AND ...](between.md) | Between the two values |
| [COALESCE](coalesce.md)|Returns the first non-null value|
| [IN()](in.md) | In the collection |
| [IS](is.md) | Test whether the value is a Boolean value. If it is a Boolean value, it returns "true" |
| [IS NOT](is-not.md) | Test whether the value is a Boolean value, negative usage of IS |
| [IS NOT NULL](is-not-null.md) | Not empty |
| [IS NULL](is-null.md) | empty |
| [ISNULL](function_isnull.md) | Use instead of `=` to test whether the value is `NULL`. |
| [LIKE](like.md) | Fuzzy Match |
| [ILIKE](ilike.md) | Fuzzy matching, same as LIKE. But it is not case sensitive. |
| [NOT BETWEEN ... AND ...](not-between.md) | Not between two values |
| [NOT IN](not-in.md) | Abbreviation of multiple `XOR` conditions |
| [NOT LIKE](not-like.md) | N fuzzy matching, negative usage of Like |

The results of the comparison operation are `TRUE`, `FALSE` or `NULL`. These operations are valid for both numbers and strings. A string can be automatically converted to a number, and a number can be automatically converted to a string as needed.

The following comparison operators can be used not only to compare scalar operations, but also to compare line operations:

```text
= > < >= <= <> !=
```