4. Elements of OpenSQL Statements : Operators : Arithmetic Operators
 
Share this page                  
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):
Arithmetic Operator
Description
+ and -
plus, minus (unary)
* and /
multiplication, division (binary)
+ and -
addition, subtraction (binary)
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 (*).