On this page

    Categories: Boolean, Datatype


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


    IS_SUBSTR(expression1 string, expression2 string) → boolean

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


    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