Mega Code Archive

 

Categories / MSSQL Tutorial / Math Functions

 

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)