Determine and return the sign of a number.
| SELECT SIGN(255.5); |
The SIGN() function indicates the sign of a number, returning:
| SIGN(number) |
|
Parameter |
Description |
|
number |
Required: The number for which to determine the sign. |
|
Works in: |
SQL Server (beginning from 2008), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse |
Determine and return the sign of a given number.
| SELECT SIGN(-12); |