Numeric Functions

Numeric functions are used with numeric values. Some numeric functions can also be used with interval and bigdatetime values. Examples of numeric functions include round () and sqrt ().

• acos()
  Scalar. Returns the arccosine of a given value.
• asin()
  Scalar. Returns the arcsine of a given value.
• atan()
  Scalar. Returns the arctangent of a given value.
• atan2()
  Scalar. Returns the arctangent of the quotient of two given values.
• avgof()
  Scalar. Returns the average value of multiple expressions, ignoring NULL parameters.
• bitand()
  Scalar. Returns the result of performing a bitwise AND operation on two expressions.
• bitclear()
  Scalar. Returns the value of an expression after setting a specific bit to zero.
• bitflag()
  Scalar. Returns a value with all bits set to zero, except the specified bit.
• bitflaglong()
  Scalar. Returns a value with all bits set to zero, except a specified bit.
• bitmask()
  Scalar. Returns a value with all bits set to 0 except a specified range of bits.
• bitmasklong()
  Scalar. Returns a value with all bits set to 0, except a specified range of bits.
• bitnot()
  Scalar. Returns the value of an expression with all bits inverted.
• bitor()
  Scalar. Returns the results of performing a bitwise OR operation on two expressions.
• bitset()
  Scalar. Returns the value of an expression after setting a specific bit to 1.
• bitshiftleft()
  Scalar. Returns the value of an expression after shifting the bits left a specific number of positions.
• bitshiftright()
  Scalar. Returns the value of an expression after shifting the bits right a specific number of positions.
• bittest()
  Scalar. Returns the value of a specific bit in a binary value.
• bittoggle()
  Scalar. Returns the value of an expression after inverting the value of a specific bit.
• bitxor()
  Scalar. Returns the results of performing a bitwise exclusive OR (XOR) operation on two expressions.
• cbrt()
  Scalar. Returns the cube root of a number.
• ceil()
  Scalar. Rounds a number up to the nearest whole number..
• compare()
  Scalar. Determines which of two values is larger.
• concat()
  Returns the concatenation of two given binary values OR one or more string values.
• cos()
  Scalar. Returns the cosine of a given value expressed in radians.
• cosd()
  Scalar. Returns the cosine of a given value, expressed in degrees.
• cosh()
  Scalar. Returns the hyperbolic cosine of a given value expressed in radians.
• distance()
  Scalar. Returns a value representing the distance between two points in two or three dimensions.
• distancesquared()
  Scalar. Returns a number representing the square of the distance between two points in either two or three dimensions.
• exp()
  Returns the value of e (the base of the natural logarithm) raised to the power of a given number.
• floor()
  Scalar. Rounds a number down.
• isnull()
  Scalar. Determines if an expression is NULL.
• ln()
  Scalar. Returns the natural logarithm of a given number.
• log2()
  Scalar. Returns the logarithm of a given value to the base 2.
• log10()
  Scalar. Returns the logarithm of a given value to a base of 10.
• logx()
  Scalar. Returns the logarithm of a given value to a specified base.
• maxof()
  Scalar. Returns the maximum value from a list of expressions.
• minof()
  Scalar. Returns the minimum value from a list of expressions.
• nextval()
  Scalar. Returns a value larger than that returned by the previous call. The first call returns 1.
• pi()
  Scalar. Returns a numerical approximation of the constant pi.
• power()
  Scalar. Returns the value of a given base raised to a specified exponent.
• random()
  Scalar. Returns a random value greater than or equal to 0 and less than 1.
• round()
  Scalar. Returns a number rounded to the specified number of digits.
• sign()
  Scalar. Determines whether a given value is positive or negative.
• sin()
  Scalar. Returns the sine of a given value.
• sind()
  Returns the sine of a given value, expressed in degrees.
• sinh()
  Scalar. Returns the hyperbolic sine of a given value.
• sqrt()
  Scalar. Returns the square root of a given number.
• tan()
  Scalar. Returns the tangent of a given value.
• tand()
  Scalar. Returns the tangent of a given value, expressed in degrees.
• tanh()
  Scalar. Returns the hyperbolic tangent of a given value.