NJMS Faculty - #interest#

SELECT MP.MBMID, FName, Minitial, LName, Dept.DeptID, DeptDisplayName, resinterest FROM MBM.MBMPerson MP, MBM.PersonInfo PI, MBM.PersonDept PD, MBM.Department Dept WHERE (LOWER(PI.keywords) like '%#LCase(interest)#%' OR LOWER(PI.ResInterest) like '%#LCase(interest)#%') AND PI.TMBMID = MP.MBMID AND PI.TMBMID = PD.MBMID AND PD.DeptID = Dept.DeptID AND MP.status = 'A' ORDER BY LName Search results for interests #interest#:
Name Research Interest Department/Unit
#decodeNiceDatabase(Fname)# #LEFT(minitial,1)#. #decodeNiceDatabase(Lname)# #resinterest# #decodeNiceDatabase(DeptDisplayName)#
#decodeNiceDatabase(DeptDisplayName)#
Search results for interest #interest#: No records found.