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.
- Calculating overrideable attributes
- Combining results from Full Outer Join
- String concatenation