Categories: Boolean, Datatype

IS_SUBSTR

Returns true if a string is contained within another string. The comparison is case-sensitive.

Syntax

IS_SUBSTR(expression1 string, expression2 string) → boolean

• expression1: The input expression to search.
• expression2: The string to search for in the specified expression.

Examples

SELECT IS_SUBSTR('dremio', 'emi')
-- True

SELECT city, IS_SUBSTR(city, 'CUSHMAN') FROM  "Samples"."samples.dremio.com"."zips.json"
LIMIT 3

-- city, EXPR$1
-- AGAWAM, false
-- CUSHMAN, true
-- BARRE, false