This weeks tip:
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:
| Comparison | Meaning |
| = | Equal |
| > | Greater Than |
| < | Less Than |
| >= | Greater than or equal to |
| <= | Less than or equal to |
| <> | Not equal |
| != | Not equal |
| !< | Not less than |
| !> | Not greater than |
