Arithmetic Operators
Arithmetic operators are used to combine numeric expressions arithmetically to form other numeric expressions. Valid OpenSQL arithmetic operators are (in descending order of precedence):
Unary operators group from right to left and binary operators group from left to right. The unary minus (-) can be used to reverse the algebraic sign of a value.
Use parentheses to force the desired order of precedence. For example:
(job.lowsal + 1000) * 12
is an expression in which the parentheses force the addition operator (+) to take precedence over the multiplication operator (*).
Last modified date: 04/03/2024