Explanatory Question
Real life Example of Coalesce() function
Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.
According to the MSDN Books online COALESCE() returns the first Non NULL value. Let's understand this with an example.
Consider the Employees Table below. Not all employees have their First, Midde and Last Names filled. Some of the employees has First name missing,
First read the answer fully, then try to explain it in your own words. After that, open a few related questions and compare the concepts. This method helps you remember the topic for a longer time and improves exam preparation.