We need to go over one more thing before we’re fully done with the
LIKE operator. Namely, case insensitive matching.
By definition, the
LIKE operator is case sensitive: it’ll match the exact text pattern you provided. For example,
LIKE '%foobar%' will match only records that contain
Case insensitive matching
Often, we don’t really care about case sensitivity, because the data in the warehouse is often preprocessed. For example, all emails are converted to lower case.
Some user-generated data might be...