NULL Values Involved in String Operations in SQL Server

Q

What Happens If NULL Values Are Involved in String Operations in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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 'FyiCenter'+NULL; 
GO
----------
NULL

SELECT LEN(NULL); 
GO
----------
NULL

SELECT REVERSE(NULL); 
GO
----------
NULL

 

Working with NULL Values in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-05, 230👍, 0💬