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 '
like
String comparison
with wildcard characters. The operation returns a boolean
Example:
'abc'
like 'a*' returns
'abcd'
like 'a?c*' returns
'abc'
like 'a??bc' returns