e IS NULL OR m.endDate >= GETDATE())
ORDER BY m.secondary, CASE WHEN r.personID2 IS NULL THEN 1 ELSE 0 END,... END, CASE WHEN l.mailing = 1 THEN 0 ELSE 1 END,l.secondary)
--************** Address CASE statement for PO b
| Personal Contact Information > Secondary Email |
| Diploma First Name | Student Info... if I drop a class, take course work through Post -Secondary Enrollment Option, Credit Flexibility, or other e