WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
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