| 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) |