COMPARISON Functions
All functions > COMPARISON
All functions in the COMPARISON category.
Equality
| Function | Description |
|---|---|
EQUALS | Returns TRUE if the first value equals the second value |
NOT_EQUALS | Returns TRUE if the first value does not equal the second value |
IS_NULL | Returns TRUE if the expression evaluates to NULL. |
IS_NOT_NULL | Returns TRUE if the expression does NOT evaluate to NULL. |
DISPLAYS_AS | Returns TRUE if two values are not distinct, treating NULL values as comparable. |
NOT_DISPLAYS_AS | Returns TRUE if two values are distinct, treating NULL values as comparable. |
Ordering
| Function | Description |
|---|---|
LESS_THAN | Returns TRUE if the first value is strictly less than the second value |
LESS_THAN_OR_EQUALS | Returns TRUE if the first value is less than or equal to the second value |
GREATER_THAN | Returns TRUE if the first value is strictly greater than the second value |
GREATER_THAN_OR_EQUALS | Returns TRUE if the first value is greater than or equal to the second value |
BETWEEN | Returns TRUE if a value is within a specified range (inclusive) |
NOT_BETWEEN | Returns TRUE if a value is NOT within a specified range (inclusive). |
LEAST | Returns the least (minimum) value from a list of arguments. |
GREATEST | Returns the greatest (maximum) value from a list of arguments. |
Pattern Matching
| Function | Description |
|---|---|
LIKE | Returns TRUE if a string matches a specified pattern with wildcards. |
NOT_LIKE | Returns TRUE if a string does NOT match a specified pattern with wildcards. |
Set Operations
| Function | Description |
|---|---|
IN_LIST | Returns TRUE if a value exists in a list of values. |
NOT_IN_LIST | Returns TRUE if a value does NOT exist in a list of values. |
Summary
- Functions in COMPARISON: 18
This documentation is automatically generated from the FeatureMesh registry.
On this page