equal

# Differences

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

 equal [2015/09/23 20:27] 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 + ​ + + + **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 |

### Page Tools 