Table of string operators
You can use these operators in expressions whose operands represent string values:
| 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) |