To avoid this you can use:

SET CONCAT_NULL_YIELDS_NULL OFF

This will prevent a field where the value is NULL from making the entire result NULL as well.