Using T-SQL's COALESCE Function

added by Richard Carr
7/18/2013 1:13:16 PM

6 Kicks, 129 Views

In denormalised databases, such as those used for reporting purposes or to feed data warehouses, it is common to need to query information from a group of columns where only one has a value. This can be simplified with the coalesce function.