SELECT Patient_Id FROM #Request.prefix_db_agency#.pPatients WHERE Patient_Id = '#thevalue#' AND Loc_ID = '#session.AgencyId#' SELECT Patient_Id FROM #Request.prefix_db_agency#.pPatients WHERE Patient_Id = '#thevalue#' AND Loc_ID = '#session.AgencyId#' #theurl#;