at the top of your script set concat nulls on then off at bottom 🙂
SET CONCAT_NULL_YIELDS_NULL { ON | OFF }
When SET CONCAT_NULL_YIELDS_NULL is ON, concatenating a null value with a string yields a NULL result. For example, SELECT 'abc' + NULL yields NULL. When SET CONCAT_NULL_YIELDS_NULL is OFF, concatenating a null value with a string yields the string itself (the null value is treated as an empty string). For example, SELECT 'abc' + NULL yields abc.
***The first step is always the hardest *******