Skip to main content
Version: current [25.x]

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

IS_SUBSTR example 
SELECT IS_SUBSTR('dremio', 'emi')
-- True
IS_SUBSTR example 
SELECT city, IS_SUBSTR(city, 'CUSHMAN') FROM  "Samples"."samples.dremio.com"."zips.json"
LIMIT 3
-- city, EXPR$1
-- AGAWAM, false
-- CUSHMAN, true
-- BARRE, false