# Numeric Functions

The table below lists the numeric functions included in the ODBC scalar function set that can be used with the BASIS ODBC Driver.

Arguments denoted as numeric_exp can be the name of a column (of any numeric type), the result of another scalar function that returns a numeric value, a mathematical operation, or a numeric literal.

Arguments denoted as float_exp can be the name of a column (of type FLOAT, DOUBLE, REAL, or DECIMAL), the result of another scalar function that returns a float value, a mathematical operation, or a numeric literal.

Arguments denoted as integer_exp can be the name of a column (of type signed or unsigned INTEGER), the result of another scalar function that returns an integer value, a mathematical operation, or an integer literal.

Function |
Description |

ABS(numeric_exp) |
Returns the absolute value of numeric_exp. |

ACOS(numeric_exp) |
Returns the arccosine of float_exp as an angle expressed in radians. |

ASIN(numeric_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(double,double) |
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. |

COS(float_exp) |
Returns the cosine of the float_exp as an angle expressed in radians. |

COT(numeric_exp) |
Returns the cotangent of numeric_exp as an angle expressed in radians. |

DEGREES(numeric_exp) |
Returns the number of degrees converted from numeric_exp radians. |

EXP(numeric_exp) |
Returns the exponential value of float_exp. |

FLOOR(numeric_exp) |
Returns the largest integer less than or equal to numeric_exp. |

LOG(numeric_exp) |
Returns the natural logarithm of float_exp. |

LOG10(numeric_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() |
The numeric literal for PI defined as: |

POWER(numeric_exp) |
Returns the value of numeric_exp to the power of integer_exp. |

RADIANS(numeric_exp) |
Returns the number of radians concerted from numeric_exp degrees. |

RAND(numeric_exp) |
Generates a random number using numeric_exp as a seed. |

ROUND(numeric_exp, integer_exp) |
Rounds numeric_exp to integer_exp decimal places. |

SIGN(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 the float_exp as an angle expressed in radians. |

SQRT(numeric_exp) |
Returns the square root of numeric_exp. |

TAN(numeric_exp) |
Returns the tangent of numeric_exp as an angle expressed in radians. |

TRUNCATE(numeric_exp) |
Returns numeric_exp with the decimal portion removed. |

## Example

Select IFF(SIGN(curr_bal)>=0, '+', '-')+STR(ABS(curr_bal)) from customer