We started learning about regular expressions by reproducing the
LIKE operator and all it’s features (wildcards for a single character and for the beginning/end of text).
In this lesson let’s do the same and implement something similar to the
How can we achieve case insensitive matching with regular expressions? Here’s a virtual table for you to play with:
WITH strings AS ( SELECT 'foobar' AS string UNION SELECT 'FOOBAR' AS string UNION SELECT 'fooBAR' AS string ) SELECT string FROM strings
Think about it for a couple of minutes...