Patient Room
Patient Room Suite
SELECT * FROM doctors where facility is not NULL And IsDeleted = '0' And facility like '%Patient Room Suite%' ORDER BY empty,priority desc , dname asc;