Returns the sign (+1 for positive, 0, or -1 for negative) of the specified value.
sign(numeric)
is any exact numeric (numeric, dec, decimal, tinyint, smallint, or int), approximate numeric (float, real, or double precision), or money column, variable, constant expression, or a combination of these.
select sign(-123)
----------- -1
select sign(0)
----------- 0
select sign(123)
----------- 1
sign, a mathematical function, returns the positive (+1), zero (0), or negative (-1).
Results are of the same type, and have the same precision and scale, as the numeric expression.
For general information about mathematical functions, see “Mathematical functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute sign.
