MSSQLNumeric FunctionsABS
CHAR

ABSNumeric Functions

CEILING

Returns the absolute value.

Syntax

ABS(n)

Example

Enter values below to update the example in real time.

budget
actual_cost
gap
projects
SELECT ABS(budget - actual_cost) AS gap FROM projects;