IBM Integration Bus, Version 9.0.0.8 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

ENDSWITH function

ENDSWITH is a string manipulation function that manipulates all string data types (BIT, BLOB, and CHARACTER), and returns a Boolean value to indicate whether one string ends with another.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-ENDSWITH--(--SourceExpression--,--SearchExpression--)-------><

ENDSWITH returns TRUE if SourceExpression ends with SearchExpression, otherwise it returns FALSE.

The parameter strings for both SearchExpression and SourceExpression can be of the CHARACTER, BLOB, or BIT data type, but must be of the same data type.

If any parameter is NULL, the result is NULL.

Examples

ENDSWITH('Hello World!', 'World!');
returns TRUE.
ENDSWITH('Hello World!', 'World');
returns FALSE.

ak64980_.htm | Last updated Friday, 21 July 2017