• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • FLOOR()
  • FORMAT()
  • HEX()
  • OCT()
  • RAND()
  • ROUND()
  • UNHEX()

ABS()

Return the absolute value of the evaluated expression result.

Prototype

mixed ABS(expression expression)

Parameter

• expression - Expression that should evaluate to a integer or decimal number.

Example

SELECT OID, Date, ABS(Total) AS AbsTotal FROM Invoice

Return

Absolute value of the evaluated expression result.

• < Math
• CEIL() >