Note that it is important to use the ISNULL() function when concatenating fields together, or the results will be inaccurate. This is because when joining strings together, a null value eats up the other values, causing the whole string to be null.

Optionally, you can use a space or other string to join them, but this is not required: