The following table describes some of the useful built-in functions that extend the basic set of numeric operands.

Table 1. Arithmetic built-in functions

Function	Description
ABSOLUTE	Returns the absolute value of a numeric value.
EXP	Returns the result of raising a number to a power. The number is called the base and the power is called the exponent.
LOG	Calculates the logarithm of an expression using a specified base and returns that logarithm as a DECIMAL value.
MAXIMUM	Compares two or more values and returns the largest value.
MINIMUM	Compares two or more values and returns the smallest.
MODULO	Determines the remainder after division.
RANDOM	Returns a random INTEGER value between two integers (inclusive).
ROUND	Rounds a decimal expression to a specified number of places after the decimal point.
SQRT	Returns the square root (as a DECIMAL value) of an expression you specify.
TRUNCATE	Truncates a decimal expression to a specified number of decimal places, returning a decimal value.