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