SELECT *
FROM COE_FACSTAFFDIRECTORY
WHERE (FacultyOrStaff = 'Staff') AND (ForS_Subcat IN
('Exempt','NonExempt'))
AND (PrimaryDept = 'TLPL')
ORDER BY LastName, FirstName
#LastName#, #FirstName# #HighestDegree# #Title# #ID_DID#@umd.edu #PHONE# |
SELECT *
FROM COE_FACSTAFFDIRECTORY
WHERE (FacultyOrStaff = 'Staff') AND (ForS_Subcat IN
('Exempt','NonExempt'))
AND (PrimaryDept = 'TLPL')
ORDER BY LastName, FirstName
#LastName#, #FirstName# #HighestDegree# #Title# #ID_DID#@umd.edu #PHONE# |