Skip to main content

CONTAINS

Returns true if the string contains the substring.

Syntax

CONTAINS ( string_expression, substring ) 

Arguments

string_expression
A valid string expression.

substring A string expression that may be contained in string_expression.

Return Type

Returns a BOOLEAN.

Examples

Examples in this section use the example blockchain.

The following example checks whether "d" is contained within each str record.

SELECT CONTAINS(str, "d") FROM example;

Response:

CONTAINS [STRING]
NULL
TRUE
FALSE
TRUE