⟩ What Happens If NULL Values Are Involved in String Operations?
If NULL values are involved in string operations, the result will be string NULL values. The following tutorial script shows you some good examples:
SELECT 'GlobalGuideLine'+NULL;
GO
----------
NULL
SELECT LEN(NULL);
GO
----------
NULL
SELECT REVERSE(NULL);
GO
----------
NULL
