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. |