Real life Example of Coalesce() function

Question

Accepted Answer

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,

Real life Example of Coalesce() function

Answer with Explanation