abs

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.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute abs.