TSQL: Some interesting usages of Coalesce

added by mehroz
7/29/2010 8:02:09 AM

1 Kicks, 83 Views

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 post. Instead, I will only present a few interesting usages. <ul> <li>Calculating overrideable attributes</li> <li>Combining results from Full Outer Join</li> <li>String concatenation</li> </ul>