This shows you the differences between two versions of the page.
— |
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 | |