Try OpenEdge Now
SQL Reference
SQL Reference
:
OpenEdge SQL Language Elements
:
Data types
:
Relational operators
:
Numeric arithmetic expressions
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.
Syntax
[
+
|
-
]
{
numeric_literal
|
numeric_expr
}
[
{
+
|
-
|
*
|
/
}
numeric_arith_expr
]
Parameters
+
|
-
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
Unary plus or minus