Numeric Functions
The following operators and functions are available for manipulating the numeric information:
Functions | Description |
---|---|
+, - * / % | Use these operators to add, subtract, multiply, divide, or compute the remainder after the division (%) of two numbers. |
ABS(numeric) | This operator returns the absolute value of the numeric expression. |
Floor(numeric) | This operator returns the largest integer less than or equal to the given numeric value. |
Round(numeric, length) | This operator returns the numeric value rounded off to the specified size or precision. |
Sign(numeric) | This operator returns the character of the numeric expression (-1, 0, 1). |
Integer(character) | This operator returns the character value converted to an integer (whole number) or EMPTY if the character value is not a valid integer. |
Numeric(character) | This operator returns the character value converted to a numeric value (with decimal places) or EMPTY if the character value is not a valid numeric value. |