Character Operators

You can join and compare character data using the character operators +, -, and $. The following table lists the character expression operators in order of precedence.

Character Operators

Operator Action Code
+
Concatenation. Joins two strings, a string and a field, or a string and a variable.
? 'Good ' + 'morning'
-
Concatenation. Removes trailing blanks from the element preceding the operator then joins two elements.
? customer.first - customer.last
$
Comparison. Seeks one character expression within another.
? 'father' $ 'grandfather'
? 'Main' $ customer.address

See Also

$ Operator | Character Data Type | Creating Character Expressions | Operators