SIGN « Math Functions « SQL Server / T-SQL






1.SIGN: return a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0