bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server ABS() Function

Example

SELECT Abs(-243.5) AS AbsNum;

Definition and Usage

The ABS() function returns the absolute value of a number.

Syntax

ABS(
number
)

Parameter Values

ParameterDescription
numberRequired. A numeric value

Technical Details

Works in:SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Previous

SQL Server UPPER() Function

Next

SQL Server ACOS() Function