![ilike snowflake ilike snowflake](https://memeguy.com/photos/images/like-snowflakes-339346.jpg)
First we create a small table with some sample data: The function is called ILIKE and it is syntactic sugar for the combination of UPPER and LIKE. LIKE, ILIKE, and RLIKE all perform similar operations however, RLIKE uses POSIX EXE (Extended Regular Expression) syntax instead of the SQL pattern syntax used by LIKE and ILIKE. Unlike the LIKE function, string matching is case-insensitive. Today I have a small blog post about a neat little function I discovered last week – with thanks to my German colleague, who wants to remain anonymous. ILIKE ¶ Allows matching of strings based on comparison with a pattern. It might be some SQL function that I’d really like to be in SQL Server, it might be something else.
![ilike snowflake ilike snowflake](https://www.lilywashere.gr/images/blog/2019/wiln/january/8a.jpg)
In each part, I’ll highlight something that I think it’s interesting enough to share. To find any of those you'll need to use a substring. Normally you would use UPPER on the column (which is a bad idea in SQL Server, because then no index can be used), but here we can just use the ILIKE function: Hooray All three rows returned. Luckily there’s the ILIKE clause, which has the exact same functionality as LIKE, but it ignores any casing. Alas, it returns only one row, because Snowflake is case-sensitive by default. Otherwise you might not get the result you want. When you write a SELECT statement using LIKE in the WHERE clause, this is something you need to take into account.
#ILIKE SNOWFLAKE SERIES#
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). ILIKE and Regular Expressions By default Snowflake is case sensitive.