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 (*).