Using Coalesce to Clean Up Reports

One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?

Short Circuit or not?

COALESCE

COALESCE in SQL Server

Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.

COALESCE

COALESCE

COALESCE - 2

COALESCE

Create string from table

This simple script retrieves a range of values from a table and presents the results as a string.