I am trying to implement this with a more complicated query. Thoughts on a where clause like this, or one using between and dates? ( VW_Person.Person_Number = :APP_PERSON_PERSON Or :APP_IS_ADMIN = 'Y') And ( :P21_CRITERIA_STATUS = 'A' AND STATUS_TRAN_PERSON = 'ACTIVE' OR :P21_CRITERIA_STATUS = 'I' AND STATUS_TRAN_PERSON = 'INACTIVE' OR :P21_CRITERIA_STATUS NOT IN ('A', 'I')) And (:P21_CRITERIA_EPRGENRL_ID IS NULL OR Employer_ID = :P21_CRITERIA_Employer_ID); Note: Criteria_Status is a group letting the user select (A)ctive, (I)nactive, or Al(L) people. Thanks Joe