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 about syntax and use of the LIKE and MATCHES operators, see the Condition segment in the HCL Informix® Guide to SQL: Syntax.