SQL Reference

Numeric arithmetic expressions

Numeric arithmetic expressions compute a value using addition, subtraction, multiplication, and division operations on numeric literals and expressions that evaluate to any numeric data type.

+ - numeric_literal numeric_expr + - * / numeric_arith_expr |

+

-Unary operators.

numeric_literal

Number value.

numeric_expr

Evaluates to a numeric data type:

+

- * /Operators for addition, subtraction, multiplication, and division. SQL evaluates numeric arithmetic expressions in the following order:

Unary plus or minus

Expressions in parentheses

Multiplication and division, from left to right

Addition and subtraction, from left to right

© 2017 Progress Software Corporation and/or one of its subsidiaries or affiliates. All rights reserved.

Progress® OpenEdge® Release 11.7