Question: what is the difference between the isnull and coalesce functions?
Answer: COALESCE and ISNULL are the two functions that will return a NON- NULL value instead of a NULL. The data type of the output returned by COALESCE will be the data type with highest precedence, whereas data type of the ISNULL output will be the data type of the first input.