In this article
The expression model supports various binary arithmetic, comparison, and logical operators for operands of different data types.
| Binary Arithmetic operations |
| Operator | Operands | Result |
| + | Numeric | Numeric |
+ (concatenation) | Text | Text |
| - | Numeric | Numeric |
| * | Numeric | Numeric |
| / | Numeric | Numeric |
| % (modulo) | Numeric | Numeric |
| Comparison operations |
| Operator | Operands | Result |
| = | Boolean, Integer, Real, Text, DateTime, Category | Boolean |
| ≠ | Boolean, Integer, Real, Text, DateTime, Category | Boolean |
| > | Integer, Real, DateTime | Boolean |
| ≥ | Integer, Real, DateTime | Boolean |
| < | Integer, Real, DateTime | Boolean |
| ≤ | Integer, Real, DateTime | Boolean |
| Logical operations |
| Operator | Operand(s) | Result |
| AND | Boolean | Boolean |
| OR | Boolean | Boolean |
| NOT | Boolean | Boolean |
| IS NULL | Any | Boolean |
| IS NOT NULL | Any | Boolean |