Very good question indeed. NULL does not mean NULL. try running the following statement. This will always return 'NOT Matched' because NULL cannot be compared to NULL as it means nothing or its unknown. 😀

SELECT CASE NULL WHEN NULL THEN 'Match' ELSE 'NOT Matched' END