Numeric functions

The following table describes the supported numeric functions.

Function	Description
abs	Returns the absolute value of a numeric expression.
acos	Returns the arc cosine of a number, in radians.
asin	Returns the arc sine of a number, in radians.
atan	Returns the arc tangent of a number, in radians.
atn2	Returns the arc tangent of two variables.
ceiling	Returns the smallest integer greater than or equal to a given number.
cos	Returns the cosine of a number, in radians.
cot	Returns the cotangent of a number, in radians.
degrees	Converts an angle from radians to degrees.
exp	Returns the exponential value of a number.
floor	Returns the largest integer less than or equal to a given number.
isnumeric	Returns 1 if an expression is numeric; otherwise, 0.
log	Returns the natural logarithm of a number.
log10	Returns the base-10 logarithm of a number.
pi	Returns the constant π.
power	Returns a number raised to the power of an exponent, where the base is the first argument and the exponent is the second.
radians	Converts an angle from degrees to radians.
rand	Returns a random floating-point value between 0 and 1.
rand2	Returns a random value between 0 and 1 using a seed, computed for each row in the select list.
round	Rounds a number to a specified number of decimal places.
sign	Returns the sign of a number: -1 if the number is negative, 0 if the number is 0, and 1 if the number is positive.
sin	Returns the sine of an angle, in radians.
square	Returns the square of a value expressed as a float.
sqrt	Returns the square root of a number.
tan	Returns the tangent of an angle, in radians.

For more information, see SAP ASE functions.