Thanks, my CASE is what I was worried about. If all I have to do is change the ORs to ANDs, then I'm happy. I was able to find plenty of examples of CASE within WHERE, but nothing which looked similar to this.
What exactly were you worried about with the CASE statement?