Comparison functions evaluate to Boolean by comparing values to the left and right of the operator.
Function | Template format | Return type |
is among | <field> is among <value>, <value>, [add value] *List of values of same data type as left side of comparison |
Boolean |
is not among | <field> is not among <value>, <value>, [add value] *List of values of same data type as left side of comparison |
Boolean |
is at least | <numeric> is at least <numeric expression> |
Boolean |
is at most | <numeric> is at most <numeric expression> |
Boolean |
is between | <date or numeric> is between <date or numeric expression> and <date or numeric expression> |
Boolean |
is not between | <date or numeric> is not between <date or numeric expression> and <date numeric expression> |
Boolean |
is equal to | <Field> is equal to <value> *value of same data type as left side of comparison |
Boolean |
is Not Null | <field> is not NULL | Boolean |
is NULL | <field> is NULL | Boolean |
is not empty | <field> is not empty | Boolean |
is a number | <value> is a number | Boolean |
is greater than | <numeric> is greater than <numeric expression> |
Boolean |
is greater than or equal to | <numeric> is greater than or equal to <numeric expression> |
Boolean |
is less than | <numeric> is less than <numeric expression> |
Boolean |
is less than or equal to | <numeric> is less than or equal to <numeric expression> |
Boolean |
is after | <date> is after <date expression> |
Boolean |
is on or after | <date> is on or after <date expression> |
Boolean |
is not after | <date> is not after <date expression> |
Boolean |
is before | <date> is before <date expression> |
Boolean |
is not before | <date> is not before <date expression> |
Boolean |
is on or before | <date> is on or before <date expression> |
Boolean |
is null or empty | <field> is null or empty | Boolean |
is not null or empty | <field> is not null or empty | Boolean |
is TRUE | <Boolean> is TRUE | Boolean |
is FALSE | < Boolean> is FALSE | Boolean |
Comments
0 comments
Please sign in to leave a comment.