kaveer
5/11/2017 - 9:36 AM

Merge two columns in select statement

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