SQL Key Learnings LIKE VS ILIKE LIKE : LIKE is case sensitive, part of standard SQL practice. ILIKE: ILIKE is case in-sensitive, available only in postgresql and snowflake.