Numeric functions

Numeric functions

 

ROUND(n,decimals) - The Round function rounds a real-type value to an integer-type value. 0.5 is always processed to largest integer number. This is NOT banker rounding.

 

INT(number) - Returns the integer part of a real number.

 

FRAC(number) - Returns the fractional part of a real number.

 

POWER(base, exponent) - Raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0.

 

INTPOWER(base, exponent) - Calculates the integral power of a base value. IntPower raises Base to the power specified by Exponent.