This topic lists the ESQL string manipulation functions.
Most of the following functions manipulate all string data types (BIT, BLOB, and CHARACTER). Exceptions to this are UPPER, LOWER, LCASE, UCASE, and SPACE, which operate only on character strings.
In these descriptions, the term singleton refers to a single part (BIT, BLOB, or CHARACTER) within a string of that type.
In addition to the functions described here, you can use the logical OR operator to perform various calculations on ESQL string manipulation values.
To concatenate two strings, use the ESQL string operator.