Snowflake: LIKE, iLIKE And rLIKE

Photo by Marten Newhall

Snowflake offers a variety of options that we can use for comparing strings and pattern searching. Let’s have a quick look of LIKE, iLIKE and rLIKE operators, identify their strengths and learn how it can help us from our day to day Snowflake SQL life.

LIKE

Syntax:

-- 1st syntax
<subject> LIKE <pattern> [ ESCAPE <escape> ]

-- 2nd syntax
LIKE( <subject>…