abs

Description

Returns the absolute value of an expression.

Syntax

abs(numeric_expression)

Parameters

numeric_expression

is a column, variable, or expression with datatype that 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

abs, a mathematical function, returns the absolute value of a given expression. Results are of the same type and have the same precision and scale as the numeric expression.

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