Converts a number to its absolute value.

Syntax

---

ABS(<NumericExpression>)

<NumericExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT
FLOAT
DECIMAL|NUMERIC

Returns

---

Same as Input

Usage

---

The ABS function converts a numeric value to its absolute, or non-negative value.

Examples

---

SELECT ABS(Difference) AS Difference
FROM Populations

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: