abs

Description

Returns the absolute value of an expression.

Syntax

abs(numeric_expression)

Parameters

numeric_expression

is a column, variable, or expression whose datatype is an exact numeric, approximate numeric, money, or any type that can be implicitly converted to one of these types.

Examples

Example 1

Returns the absolute value of -1:

select abs(-1)
----------- 
         1

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute abs.

See also

“Mathematical functions” for general information about mathematical functions.

Functions ceiling, floor, round, sign