SQL SERVER ABSOLUTE VALUE FUNCTION ABS

SQL SERVER ABSOLUTE VALUE FUNCTION

/* HI VIEWERS, TODAY WE ARE LOOKING AT THE ABSOLUTE VALUE SQL FUNCTION IN SSMS 2012.

LET US BEGIN. */

SELECT ABS(234) AS [ABS];

/* THE ABSOLUTE VALUE ONLY WORKS FOR MATH FIGURES AS IN NUMBERS.

IT DOES NOT WORK FOR TXT VALUE */

SELECT ABS(234.60099) AS [ABS];

/* SO EVEN FOR DECIMAL NUMBERS THE ABSOLUTE VALUE FUNCTION FINDS THE EXACT VALUE
OR ABSOLUTE VALUE FOR ANY NUMBER OR DECIMAL NUMBER.

THAT IS IT */

Figure 1 ABS