T-SQL Tutorial T-SQL Advanced Database Management T-SQL References
T-SQL Tutorial T-SQL Advanced Database Management T-SQL References

T-SQL SIGN() Function

The T-SQL (Transact-SQL) SIGN() function returns a value indicating the sign of the specified number. It returns the following:

  • Returns -1, if the number is less than 0.
  • Returns 0, if the number is equal to 0.
  • Returns 1, if the number is greater than 0.

Syntax

SIGN(number)

Parameters

number Required. Specify the number to test for its sign.

Return Value

Returns a value indicating the sign of the given number.

Example 1:

The example below shows the usage of SIGN() function.

SELECT SIGN(25);
Result: 1

SELECT SIGN(-25);
Result: -1

SELECT SIGN(0);
Result: 0

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 110
Data 214
Data 3-34
Data 40
Data 5-67

The statement given below can be used to get the sign of values of column x.

SELECT *, SIGN(x) AS SIGN_Value FROM Sample;

This will produce the result as shown below:

DataxSIGN_Value
Data 1101
Data 2141
Data 3-34-1
Data 400
Data 5-67-1

❮ T-SQL Functions
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.