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)