In this article
| Function | Description |
| IsNull(a1, a2) | The value of a1 if it is not null, otherwise a2. a2 must be convertible to the type of a1. |
| Between(value, lower, upper) | Tests if a value is between the specified boundaries. Equivalent of the expression “value >= lower AND value <= upper”. All arguments must be of (compatible) numeric or date/time type. |
| In(source_value, c1[, c2,…]) | Returns true if the value of the source_value is equal to one of the values of c1, c2, etc. The first argument is expected to be an expression of numeric, text or category type. Other arguments are expected to be constants of compatible types. |
| Iif(condition, true_value[, false_value]) | Evaluates a values depending on a condition. Condition argument is expected to be a boolean expression. Other arguments can be of any (compatible) types. If the condition is true then resulting value is true_value, else false_value. false_value can be omitted, in this case it is assumed to be null. |