⟩ What Happens If NULL Values Are Involved in Arithmetic Operations?
If NULL values are involved in arithmetic operations, the result will be numeric NULL values. The following tutorial script shows you some good examples:
SELECT 7+NULL;
GO
-----------
NULL
SELECT 10.02*NULL;
GO
-----------
NULL
SELECT 4.988E+10/NULL;
GO
-----------
NULL
