SIGN functions in SQL Server

This article will show you in detail how to use SIGN () function to handle SQL Server with syntax and specific examples to make it easier to visualize and capture functions.

Describe

The SIGN function in SQL Server is used to retrieve the sign of a number or the transmitted expression.

The function will return one of the following:

• If number> 0, SIGN returns 1
• If number = 0, SIGN returns 0
• If number <0, SIGN returns -1

Syntax

To use the SIGN function in SQL Server, we use the following syntax:

 SIGN(number) 

Parameters :

• number: number passed to get the mark

Note :

• SIGN function can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

For example

See and explore some examples of SIGN functions in SQL Server.

 SELECT SIGN(-23); 
 Result: -1 
 
 SELECT SIGN(-0.1); 
 Result: -1 
 
 SELECT SIGN(0); 
 Result: 0 
 
 SELECT SIGN(0.1); 
 Result: 1 
 
 SELECT SIGN(14); 
 Result: 1 
 
 SELECT SIGN(2019-2014); 
 Result: 1 

Previous article: ROUND function in SQL Server

Next article: SUM function in SQL Server