MS SQL Server Interview Question:

What Happens If NULL Values Are Involved in String Operations?

Submitted by: Administrator

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

Submitted by: Administrator