Loading lesson path
Concept visual
Start at both ends
Return the sign of a number:
SELECT SIGN(255.5);The SIGN() function returns the sign of a number. This function will return one of the following:
Formula
If number > 0, it returns 1
If number = 0, it returns 0
If number < 0, it returns - 1number )
Required. The number to return the sign forSQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Return the sign of a number:
SELECT SIGN(-12);❮ SQL Server Functions