SELECT * FROM #Request.prefix_db_agency#.pAssessments a WHERE a.status = 0 AND a.Admit_ID = '#Admit_ID#' AND a.F26 like '1%' Order By a.F177 DESC, a.F176 ASC SELECT * FROM #Request.prefix_db_agency#.pAssessments a WHERE a.status = 0 AND a.Admit_ID = '#Admit_ID#' AND a.F26 IN ('PT Adult Evaluation') Order By a.F26 ASC