The coalesce function is a really powerful function that can help us in various scenarios.

It is described in this MSDN document so I am not going to discuss its working in this postInstead, I will only present a few interesting usages Calculating overrideable attributes Combining results from Full Outer Join String concatenation
Shout it
Voted 2009 “Best ASP.NET Hosting” by asp.netPRO Magazine!
.