Function Call	Result
`IF\_ERROR((double(10)/0), 1)`	`1.0`
`IF\_ERROR(log(-1), 1)`	`1.0`

Evaluates the given *double* or *float* `expr`, and if it resolves to infinity, return `val` Example:

Function Call	Result
`IF\_INF((double(10)/0), 999)`	`999.0`
`IF\_INF(log(-1), 999)`	`NaN`

Alias for `IF_INF(expr, val)` Evaluates the given *double* or *float* `expr`, and if it resolves to `NaN`, return `val` Example:

Function Call	Result
`IF\_NAN((double(10)/0), -1)`	`Infinity`
`IF\_NAN(log(-1), -1)`	`-1.0`

Returns `1` (true) if `expr` is infinity by IEEE standard; otherwise, returns `0` (false) Alias for `ISINFINITY` Returns `1` (true) if `expr` is not a number by IEEE standard; otherwise, returns `0` (false) Alias for `ISNAN` Returns `1` (true) if `expr` is a number by IEEE standard; otherwise, returns `0` (false) Alias for `ISNUMERIC` Returns the value of `x` \* 2^exp as a *double* Returns the value of `x` \* 2^exp as a *float* Returns whichever of `expr_a` and `expr_b` has the smaller value, based on typed comparison Returns the natural logarithm of `expr` as a *double* Returns the natural logarithm of `expr` as a *float* Alias for `LN` Returns the *base-10* logarithm of `expr` as a *double* Returns the *base-10* logarithm of `expr` as a *float* Returns the natural logarithm of one plus `expr` as a *double* Returns the natural logarithm of one plus `expr` as a *float* Returns the binary (*base-2*) logarithm of `expr` as a *double* Returns the binary (*base-2*) logarithm of `expr` as a *float* Alias for `LNF` Calculates the length of the longest series of consecutive `1` bits in the integer `expr` Calculates the remainder after integer division of `dividend` by `divisor` Returns the next representable floating-point value adjacent to `expr` in the direction of `target`, incrementing `expr` if `target` is greater, decrementing if lesser. The default value of `target` is `MAX_DOUBLE` (always increments when omitted). The return type matches the input (*float* or *double*). Returns the next representable floating-point value less than `expr`. The return type matches the input (*float* or *double*). Returns the value of *pi* Alias for `POWER` Alias for `POWERF` Returns `base` raised to the power of `exponent` as a *double* Returns `base` raised to the power of `exponent` as a *float* Returns the conversion of `expr` (in degrees) to radians as a *double* Returns the conversion of `expr` (in degrees) to radians as a *float* Returns a random floating-point value, with an optional `seed` Returns NULL if `y` is NULL; otherwise, returns `x` Returns NULL if `x` is NULL; otherwise, returns `y` Rounds `expr` to the nearest decimal number with `scale` decimal places when `scale` is a positive number; rounds to the nearest number such that the result has `-(scale)` zeros to the left of the decimal point when `scale` is negative; use `scale` of `0` to round to the nearest integer. The default value of `scale` is `0`. Examples:

Function Call	Result
`ROUND(12345.678)`	`12346`
`ROUND(12345.678, 2)`	`12345.68`
`ROUND(12345.678, 0)`	`12346`
`ROUND(12345.678, -2)`	`12300`

Returns the quotient `a / b` unless `b == 0`, in which case it returns `NULL` Determines whether a number is positive, negative, or zero; returns one of the following three values:

Expression Value	Result
positive	`1`
zero	`0`
negative	`-1`

Returns the sine of `expr` as a *double* Returns the sine of `expr` as a *float* Returns the hyperbolic sine of `expr` as a *double* Returns the hyperbolic sine of `expr` as a *float* Returns the square root of `expr` as a *double* Returns the square root of `expr` as a *float* Returns the tangent of `expr` as a *double* Returns the tangent of `expr` as a *float* Returns the hyperbolic tangent of `expr` as a *double* Returns the hyperbolic tangent of `expr` as a *float* Rounds `expr` down to the nearest decimal number with `scale` decimal places when `scale` is a positive number; rounds down to the nearest number such that the result has `-(scale)` zeros to the left of the decimal point when `scale` is negative; use `scale` of `0` to round down to the nearest integer. The default value of `scale` is `0`. Examples:

Function Call	Result
`TRUNCATE(12345.678)`	`12345`
`TRUNCATE(12345.678, 2)`	`12345.67`
`TRUNCATE(12345.678, 0)`	`12345`
`TRUNCATE(12345.678, -2)`	`12300`

Defines a set of `count` equal intervals (buckets) within the range of `min` & `max`, and puts the value of `expr` into one of those buckets, where the value is greater than or equal to the minimum value of the bucket and less than the maximum value of the bucket. Returns the 1-based number of the bucket into which the value of `expr` fell. For values smaller than `min`, `0` is returned; for values greater than or equal to `max`, `count + 1` is returned. Examples: In the following examples, a set of *5* equal buckets are defined between *0* and *10* (*0-2*, *2-4*, *4-6*, *6-8*, & *8-10*), and various values are bucketed using that set.

Function Call	Result
`WIDTH\_BUCKET(-1, 0, 10, 5)`	`0`
`WIDTH\_BUCKET(0, 0, 10, 5)`	`1`
`WIDTH\_BUCKET(5, 0, 10, 5)`	`3`
`WIDTH\_BUCKET(10, 0, 10, 5)`	`6`
`WIDTH\_BUCKET(11, 0, 10, 5)`	`6`