Text Operators

Text operators operate on character strings. The following table lists the text operators that the database server provides.

Text Operator

Operator Function

LIKE

like()

MATCHES

matches()

||

concat()

For information on syntax and use of the LIKE and MATCHES operators, see the Condition segment in the IBM Informix: Guide to SQL Syntax.