string manupulation functions in ESQL

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