Know your comparison operators! Why? It may save you some embarrassment. For example:
- There is a big difference between > and >=. When writing TSQL, sometimes the “or equal to” of the comparison greater than or equal to gets forgotten.
- Pending on the standards there is a difference! The ! preceding the =,< and > is not ANSI compliant.
- I was reviewing someone else’s code and I saw the != comparison used and I thought it meant the values really needed to be extra equal.
- I thought !< was an emoticon.
Here’s a list with links for full clarification:
|>=||Greater than or equal to|
|<=||Less than or equal to|
|!<||Not less than|
|!>||Not greater than|