# Comparison Operators and Functions

The following comparison operators and functions are supported.

| Name                      | Description                                                      |
| ------------------------- | ---------------------------------------------------------------- |
| `BETWEEN ... AND ...`     | Check if a value is within a range                               |
| `NOT BETWEEN ... AND ...` | Check if a value is not within a range                           |
| `=`                       | Equal operator                                                   |
| `<=>`                     | NULL-safe equal operator                                         |
| `>`                       | Greater than operator                                            |
| `>=`                      | Greater than or equal operator                                   |
| `<`                       | Less than operator                                               |
| `<=`                      | Less than or equal operator                                      |
| `IN()`                    | Check whether a value is in a comma-separated list of values     |
| `NOT IN()`                | Check whether a value is not in a comma-separated list of values |
| `IS`                      | Compare a value to a boolean                                     |
| `IS NOT`                  | Compare a value to the complement of a boolean                   |
| `IS NULL`                 | Check if a value is NULL                                         |
| `IS NOT NULL`             | Check if a value is not NULL                                     |
| `ISNULL()`                | Test whether the argument is NULL                                |
| `LIKE`                    | Check if a value matches a simple pattern                        |
| `NOT LIKE`                | Check if a value does not match a simple pattern                 |
| `!=, <>`                  | Not equal operator                                               |
| `strcmp()`                | Compare two strings and return -1, 0, or 1                       |

## In this section

* [BETWEEN, NOT BETWEEN](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/between-not-between.md)
* [NULL Handling](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/null-handling.md)
* [LIKE, NOT LIKE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/like-not-like.md)
* [IN(), NOT IN()](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/in-not-in.md)
* [strcmp()](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/strcmp.md)
* [Where operators can be used](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/where-operators-can-be-used.md)
* [Using Comparison Operators with Date and Time Functions](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/using-comparison-operators-with-date-and-time-functions.md)

***

Modified at: April 24, 2021

Source: [/db/v9.1/reference/sql-reference/comparison-operators-and-functions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/)

(An index of the documentation is available at /llms.txt)