Math Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Math Functions
  4. SIGN returns a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0
4>  SELECT SIGN(-23)
5> GO
-----------
         -1
(1 rows affected)