Type of operator | Operator | Operation |
Concatenation | &, + | Concatenation |
Relational (Comparison) | = | Equal to (same as) |
 | <> | Not equal to (not same as) |
 | >< | Not equal to (not same as) |
 | < | Earlier in the sort order than |
 | <= | Earlier in the sort order than or same as |
 | =< | Earlier in the sort order than or same as |
 | > | Later in the sort order than |
 | >= | Later in the sort order than or same as |
 | => | Later in the sort order than or same as |
 | Like | Contains (substring matching with wildcards) |