TIL: NULL isn't LIKE anything else in SQL Server

from blog Just Some Code, | ↗ original
How does the LIKE operator handle NULL values of a column? Let’s see what SQL Server does when using LIKE with a nullable column. When using the LIKE operator on a nullable column, SQL Server doesn’t include in the results rows with NULL values in that column. The same is true, when using NOT LIKE in a WHERE clause. Let’s see an example. Let’s...