Function |
Description |

ABS |
Returns the absolute value of a number |

ACOS |
Returns the arc cosine of a number |

ASIN |
Returns the arc sine of a number |

ATAN |
Returns the arc tangent of a number or the arc tangent of n and m |

ATAN2 |
Returns the arc tangent of n and m |

AVG |
Returns the average value of an expression |

CEIL |
Returns the smallest integer value that is greater than or equal to a number |

CEILING |
Returns the smallest integer value that is greater than or equal to a number |

COS |
Returns the cosine of a number |

COT |
Returns the cotangent of a number |

COUNT |
Returns the number of records in a select query |

DEGREES |
Converts a radian value into degrees |

DIV |
Used for integer division |

EXP |
Returns e raised to the power of number |

FLOOR |
Returns the largest integer value that is less than or equal to a number |

GREATEST |
Returns the greatest value in a list of expressions |

LEAST |
Returns the smallest value in a list of expressions |

LN |
Returns the natural logarithm of a number |

LOG |
Returns the natural logarithm of a number or the logarithm of a number to a specified base |

LOG10 |
Returns the base-10 logarithm of a number |

LOG2 |
Returns the base-2 logarithm of a number |

MAX |
Returns the maximum value of an expression |

MIN |
Returns the minimum value of an expression |

MOD |
Returns the remainder of n divided by m |

PI |
Returns the value of PI displayed with 6 decimal places |

POW |
Returns m raised to the nth power |

POWER |
Returns m raised to the nth power |

RADIANS |
Converts a value in degrees to radians |

RAND |
Returns a random number or a random number within a range |

ROUND |
Returns a number rounded to a certain number of decimal places |

SIGN |
Returns a value indicating the sign of a number |

SIN |
Returns the sine of a number |

SQRT |
Returns the square root of a number |

SUM |
Returns the summed value of an expression |

TAN |
Returns the tangent of a number |

TRUNCATE |
Returns a number truncated to a certain number of decimal places |