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