String operators
There are two string operators. One uses the string values of the operands and return a string as result. The other one compares the operands and returns a boolean value to indicate match.
& | String concatenation. The operation returns a text string, that consists of the two operand strings, one after another. |
Example: 'abc' & 'xyz' returns ' |
|
String comparison
with wildcard characters. The operation returns a boolean |
Example: 'abc' like 'a*' returns'abcd'
like 'a?c*' returns
|