Using Coalesce to Clean Up Reports

The T-SQL language is quite extensive and includes many functions that are useful for various purposes. One of the lesser used ones I encounter is COALESCE(). Recently I found myself using this to help with a report recently. I decided to include a few other cases I found when researching how this function works as a way of ensuring your reports are easy to read for clients.

This article covers some basic description of the function and then a few examples of where you can use this function.

What is COALESCE()?

This function is designed to work with NULL values