ABS

A mathematical function that returns the absolute (positive) value of the specified numeric expression. ABS changes negative values to positive values. ABS has no effect on zero or positive values.

Syntax

ABS ( numeric_expression )

Arguments

numeric_expression

Is an expression of the exact numeric or approximate numeric data type category.

Return types

Returns the same type as numeric_expression, excluding types described below:

input type

output type

smallmoney

money

bit

float

real

float

smallint

int

tinyint

int

Example

SELECT ABS(1.01e0);

See Also