ABS

Provide the absolute value of a number.

SELECT ABS(–243.5);

Definition and Usage

The ABS() function yields the absolute (positive) value of a number.

ABS(number)

Parameter	Description
number	Mandatory. A numerical value is required.

Works in:

From MySQL 4.0