Hi

SELECT CASE WHEN DX IS NULL THEN EnvelopeName + char(13)
+ ' ' + Address1 + char(13) + Address2 + char(13)
+ ' ' + Address3 + char(13) + ' ' + Address4 + char(13)
+ ' ' + Postcode + ' '
ELSE DX END AS Address, Code
FROM Entities

This works fine but I need to refine it so that returns (char(13)) are only added to rows that are not NULL but im not sure where to start any help you be appreciated.

Thanks in Advance