Release 10.1A: OpenEdge Data Management:
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.

> This is the syntax for a numeric arithmetic expression:

> Syntax
>     [ + | - ] { 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095