This is a good QOTD. Obviously brought out a lively discussion about Nulls.

Microsoft have done a good job of providing a Function that works the way most people would prefer to deal with Nulls i.e. by not having an everyday operation such as building someones Name out of its component Columns come to grief by Nulls in some of the Columns.

David