In SQL Server, the T-SQL SIGN()
function returns the sign of a number. In other words, it indicates whether or not the value is a positive number, a negative number, or zero.
You provide the number as an argument when calling the function.
The function returns the following result, depending on whether the argument is positive, negative, or zero.
- 1 if the number is positive
- -1 if the number is negative
- 0 if the number is zero