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.


'abc' & 'xyz' returns 'abcxyz'
like String comparison with wildcard characters. The operation returns a boolean True (-1) if the string before the operator is matched by the string after the operator. The second string may contain the wildcard characters * (any number of arbitrary characters) or ? (one arbitrary character).


'abc' like 'a*' returns True (-1)

'abcd' like 'a?c*' returns True (-1)

'abc' like 'a??bc' returns False (0)

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?