ABS() Function in SQL Server

ABS() function :

This function in SQL Server is used to return the absolute value of a specified number. Absolute value is used for depicting the distance of a number on the number line from 0. The direction of the number from zero is not considered since the absolute value of a number is never negative. This function takes as an argument any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type. The value returned by this function is of the same data type as the numeric data type of the argument.

Features :

This function is used to find the absolute value of a specified number.
This function accepts a single parameter.
The accepted parameter is of numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.
The returned value will be in the same data type as the numeric data type of the specified parameter.

Syntax :

SELECT ABS(number);

Parameter :

This method accepts a parameter as given below:

number: Specified numeric value whose absolute value going to be returned.

Returns :

It returns the absolute value of a specified number.

Example-1 :

Getting the absolute value 0 of a specified number 0.

SELECT ABS(0);

Output :

Example-2 :

Getting the absolute value .7 of a specified number -0.7

SELECT ABS(-0.7);

Output :

.7

Example-3 :

Using ABS() function with a variable and getting the absolute value 123 of a specified number 123.

DECLARE @Parameter_Value INT;
SET @Parameter_Value = 123;
SELECT ABS(@Parameter_Value);

Output :

Example-4 :

Using ABS() function with a variable and getting the absolute value 34.87 of a specified float value “-34.87”.

DECLARE @Parameter_Value float;
SET @Parameter_Value = -34.87;
SELECT ABS(@Parameter_Value);

Output :

34.869999999999997

Application :

This function is used to return the absolute value of a specified numeric value.

Article Tags :

SQL

DBMS-SQL

SQL-Server