Also, just as another avenue, you could use: SET CONCAT_NULL_YIELDS_NULL OFF

That causes concatenation to return a value even when it has a null value as one of the pieces being...