equal

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

equal [2015/09/23 20:27] (current)
Line 1: Line 1:
 +====== Equality and Comparison Operators - PL/HQL ======
  
 +You can use equality and comparison operators %%=, ==, <>, !=, <, >, >=, <=%% to determine if one operand is equal, not equal, less or greater than another operand.
 +
 +| = | == | Equal |
 +| <> | != | Not equal |
 +| > || Greater than |
 +| < || Less than |
 +| %%>=%% || Greater than or equal |
 +| %%<=%% || Less than or equal |
 +
 +**Syntax:**
 +
 +<​code>​
 +expr = expr 
 +expr == expr
 +expr <> expr
 +expr != expr
 +expr > expr
 +expr < expr
 +expr >= expr
 +expr <= expr
 +</​code>​
 +
 +
 +**Examples:​**
 +
 +| **Expression** | **Result** | **Result Type** |
 +| 3 = 3 | True | Boolean |
 +| 3 = 1 | False | Boolean |
 +| '​CA'​ = NULL | NULL | Boolean |
 +| 3 == 3 | True | Boolean |
 +| 3 <> 3 | False | Boolean |
 +| 3 != 3 | False | Boolean |
 +| 3 > 1 | True | Boolean |
 +| 3 < 1 | False | Boolean |
 +| 3 %%>=%% 1 | True | Boolean |
 +| 3 %%<=%% 1 | False | Boolean |