SIGN Function in SQL Server(TSQL)

 

The SIGN function determines whether a number is negative, 0, or positive.

If the number is negative, it returns -1,

If the number is 0, it returns 0,

If the number is positive, it returns +1

Look at the example;