Comparison Operators and Functions
The following comparison operators and functions are supported.
Name | Description |
---|---|
| Check if a value is within a range |
| 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 |
| Check whether a value is in a comma-separated list of values |
| Check whether a value is not in a comma-separated list of values |
| Compare a value to a boolean |
| Compare a value to the complement of a boolean |
| Check if a value is NULL |
| Check if a value is not NULL |
| Test whether the argument is NULL |
| Check if a value matches a simple pattern |
| Check if a value does not match a simple pattern |
| Not equal operator |
| Compare two strings and return -1, 0, or 1 |