Merge two columns in select statement
Coalesce(PrimaryContact.Address, ' ') + ', ' + Coalesce(PrimaryContact.PostCode, ' ') As [Current residential address with postcode]
left outer join vContactInfo PrimaryContact on PrimaryContact.ExternalID = app.ApplicationsID
and PrimaryContact.RelationshipTypeID = 1