Numeric expressions
Numeric expressions return real numbers.
This means that a function call or a named value must return a real number of these data types – DECIMAL, FLOAT, SMALLFLOAT, INTEGER, BIGINT, SMALLINT, TINYINT, or MONEY.
|
Literal number |
a base-10 representation of a real number, written as an integer or a fixed-point decimal, or in an exponential notation |
|
Function |
a function call of a function which returns exactly one value |
|
Named value |
a name of a variable of any simple data type or a constant (TRUE, FALSE, or NOTFOUND) |
|
an expression that returns TRUE, FALSE, or (in some contexts) NULL |
|
|
an expression that returns a positive or negative whole number |
If any operand of an arithmetic operator in a numeric expression is NULL, the entire expression is NULL.
The range of values in a numeric expression is of the receiving data type.