![Stony Brook University Logo and Search Bar](http://stonybrook.edu/sb/images/top-SB-red-band2.gif)
![Title Bar for Stony Brook Search](http://stonybrook.edu/sb/images/searchsbtitlebar.gif)
Search Result of First name:"", Last name:"conover" & Status: "Any"
select e.first_name||' '||e.middle_name||' '||e.last_name,e.type_person,e.mailname, e.mailbox, e.major, e.class, e.department, e.building, e.room, e.zip, e.phone from acc.person p, acc.epo e where e.person_id = p.id and p.employment_status in ('A','L') and p.type not IN ('03','04') and p.last_name like 'CONOVER%' and e.type_person != '99' and e.withhold_all is NULL and e.not_standard is NULL and rownum < 21 order by e.last_name,e.first_name,e.middle_name
No match found