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

CONTAINS function

CONTAINS 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 is present within another.

Syntax

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

CONTAINS returns TRUE if the SearchExpression is present within the SourceExpression, otherwise it returns FALSE.

The parameter strings for both SourceExpression and SearchExpression 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

CONTAINS('Hello World!', 'ello');
returns TRUE.
CONTAINS('Hello World!', 'daisy');
returns FALSE.
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:47:15


Reference topicReference topic | Version 8.0.0.7 | ak64960_