I am trying to create a query that concatenates the columns into a single column delimited with a pipe. It works, but if one of the columns are null, the answer is null. How do I make it so my query will treat null as an empty string?
I will have the same issue with date and integer.
SELECT EmpNo, AssociationName, MemberSince, Position, AssociationName + '|' + CONVERT(varchar, MemberSince) + '|' + Position AS ProfessionalAffiliationsFull
FROM dbo.EmpAssociations AS e