Demystifying the coalesce function

Coalesce() is a one of those functions that might not strike you as being very useful, mainly because it doesn't sound very exciting. But it IS useful, and might save you some time and complexity What does coalesce mean? In the English language, it ...