Blueprints To Build A Computer Desk

Sql server, concatenate a row in a SQL NULL columns

If you happen to create a stored procedure that returns a column concatenating several column base, I would be also noticed that when one of the "parts" of the concatenation is NULL, the result is NULL. Enough obvious, but quite boring like behavior.
To change the behavior of the chain you can use this option declaration