Progress
SQL-92
Guide and 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_arith_expr:

SYNTAX
[ + | - ] { numeric_literal | numeric_expr }
    [ { + | - | * | / } numeric_arith_expr ] 

+ | -

Unary operators.

numeric_literal

See the "Numeric Literals" section for details on specifying numeric literals.

numeric_expr

Evaluates to a numeric data type. See the "Data Types" section for information about expressions that can evaluate to numeric data types, including:

+ | - | * | /

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


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