Numeric Functions

The following operators and functions are available for manipulating the numeric information:

FunctionsDescription
+, - * / %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.