You can check for NULL values with the IsEmpty funtion. For empty strings you can simply check the length of the string. If it is 0, you don't need to add a space.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP