• Specifically what row selection conditions do you want?  Your sample is not clear.  But you almost certainly don't need CASE in any event.

    It sounds like you may actually need an "OR" between the main conditions, but it's too hard to tell to be sure.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.