What is the value of the query: SELECT 'Nancy' + NULL + 'Smith' when evaluated on Microsoft SQL Server?

What is the value of the query:
SELECT 'Nancy' + NULL + 'Smith'
when evaluated on Microsoft SQL Server? 




a. 'Nancy Smith'
b. 'Nancy'
c. 'NancySmith'
d. NULL





Answer: D


Learn More :