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:
+ | -
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 |