SIGN (Transact-SQL)
Applies to:
SQL Server (all supported versions)
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Transact-SQL Syntax Conventions
Syntax
SIGN ( numeric_expression )
Note
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.
Return Types
| Specified expression | Return type |
|---|---|
| bigint | bigint |
| int/smallint/tinyint | int |
| money/smallmoney | money |
| numeric/decimal | numeric/decimal |
| Other types | float |
Examples
The following example returns the SIGN values of numbers from -1 to 1.
DECLARE @value REAL
SET @value = -1
WHILE @value < 2
BEGIN
SELECT SIGN(@value)
SET NOCOUNT ON
SELECT @value = @value + 1
SET NOCOUNT OFF
END
SET NOCOUNT OFF
GO
Here is the result set.
(1 row(s) affected)
------------------------
-1.0
(1 row(s) affected)
------------------------
0.0
(1 row(s) affected)
------------------------
1.0
(1 row(s) affected)
Examples: Azure Synapse Analytics and Analytics Platform System (PDW)
The following example returns the SIGN values of three numbers.
SELECT SIGN(-125), SIGN(0), SIGN(564);
Here is the result set.
----- ----- -----
-1 0 1