SIGN (Transact-SQL)

SIGN (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

Topic link icon Transact-SQL Syntax Conventions


SIGN ( numeric_expression )
-- Azure SQL Data Warehouse and Parallel Data Warehouse
SIGN (numeric_expression )

numeric_expression

Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

Specified expression

Return type

bigint

bigint

int/smallint/tinyint

int

money/smallmoney

money

numeric/decimal

numeric/decimal

Other types

float

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)

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

Community Additions

ADD
Show:
© 2016 Microsoft