⟩ What Happens If NULL Values Are Involved in Bitwise Operations?
If NULL values are involved in bitwise operations, the result will be binary NULL values. The following tutorial script shows you some good examples:
SELECT 1 | NULL;
GO
-----------
NULL
SELECT 707 & NULL;
GO
-----------
NULL
SELECT ~NULL;
GO
-----------
NULL
