Function 

Description 

Local expression engine 

ABS(numeric_exp) 

Returns the absolute value of numeric_exp. 

+ 

ACOS(float_exp) 

Returns the arccosine of float_exp as an angle, expressed in radians. 

+ 

ASIN(float_exp) 

Returns the arcsine of float_exp as an angle, expressed in radians. 

+ 

ATAN(float_exp) 

Returns the arctangent of float_exp as an angle, expressed in radians. 

+ 

ATAN2(float_exp1, float_exp2) 

Returns the arctangent of the x and y coordinates, specified by float_exp1 and float_exp2, respectively, as an angle, expressed in radians. 

+ 

CEILING(numeric_exp) 

Returns the smallest integer greater than or equal to numeric_exp. The return value is of the same data type as the input parameter. 

+ 

COS(float_exp) 

Returns the cosine of float_exp, where float_exp is an angle expressed in radians. 

+ 

COT(float_exp) 

Returns the cotangent of float_exp, where float_exp is an angle expressed in radians. 

+ 

DEGREES(numeric_exp) 

Returns the number of degrees converted from numeric_exp radians. 

+ 

EXP(float_exp) 

Returns the exponential value of float_exp. 

+ 

FLOOR(numeric_exp) 

Returns the largest integer less than or equal to numeric_exp. The return value is of the same data type as the input parameter. 

+ 

LOG(float_exp) 

Returns the natural logarithm of float_exp. 

+ 

LOG10(float_exp) 

Returns the base 10 logarithm of float_exp. 

+ 

MOD(integer_exp1, integer_exp2) 

Returns the remainder (modulus) of integer_exp1 divided by integer_exp2. 

+ 

PI( ) 

Returns the constant value of pi as a floating-point value. 

+ 

POWER(numeric_exp, integer_exp) 

Returns the value of numeric_exp to the power of integer_exp. 

+ 

RADIANS(numeric_exp) 

Returns the number of radians converted from numeric_exp degrees. 

+ 

RAND([integer_exp]) 

Returns a random floating-point value using integer_exp as the optional seed value. 

+ 

ROUND(numeric_exp, integer_exp) 

Returns numeric_exp rounded to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is rounded to |integer_exp| places to the left of the decimal point. 

+ 

SIGN(numeric_exp) 

Returns an indicator of the sign of numeric_exp. If numeric_exp is less than zero, –1 is returned. If numeric_exp equals zero, 0 is returned. If numeric_exp is greater than zero, 1 is returned. 

+ 

SIN(float_exp) 

Returns the sine of float_exp, where float_exp is an angle expressed in radians. 

+ 

SQRT(float_exp) 

Returns the square root of float_exp. 

+ 

TAN(float_exp) 

Returns the tangent of float_exp, where float_exp is an angle expressed in radians. 

+ 

TRUNCATE(numeric_exp, integer_exp) 

Returns numeric_exp truncated to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is truncated to |integer_exp| places to the left of the decimal point. 

+