ESQL string manipulation functions

A list of the ESQL string manipulation functions that you can use.

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 that are 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.

This section covers the following topics:
CONTAINS function
ENDSWITH function
LEFT function
LENGTH function
LOWER and LCASE functions
LTRIM function
OVERLAY function
POSITION function
REPLACE function
REPLICATE function
RIGHT function
RTRIM function
SPACE function
STARTSWITH function
SUBSTRING function
TRANSLATE function
TRIM function
UPPER and UCASE functions
URLDECODE function
URLENCODE function