CONTAINS_SUBSTR

​

Syntax

​

Scalar

contains_substr(value, search)

​

Arguments

​

Returns

• Type: BOOLEAN
• Possible values: TRUE or FALSE from a case-sensitive literal substring comparison.
• NULL behavior: Returns NULL if either argument is NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT contains_substr('abc', 'b') AS found, contains_substr('abc', '') AS empty_search;

​

Case-sensitive matching

SELECT contains_substr('Spark SQL', 'SQL') AS same_case, contains_substr('Spark SQL', 'sql') AS different_case;