'+a.apt END,'') END AS StudentPrimaryContactStreetAddress,
a.city AS StudentPrimaryContactCity,
a.state AS ... c2 ON c2.personID = p2.personID
LEFT OUTER JOIN address a ON a.addressID =
(SELECT TOP 1 x.addressID FRO... endDate IS NULL OR l.endDate >= GETDATE())
JOIN address x ON x.addressID = l.addressID
WHERE m.personID... 1 THEN 0 ELSE 1 END,l.secondary)
--************** Address CASE statement for PO box. This is the library ex