Thanks again, Greg, that seemed to work at first glance, but if you replace the value of @Op5 with null, no results are returned, where ResultID 116 in the above...

Thanks Greg, I like the straightforward approach, but I'm getting a "Subquery returned more than 1 value" error when attempting to run your query. The first subquery (starting on line...

Thank you ron k, your solution worked brilliantly!

I think I may have spoken too soon. Your solution seemed to have worked initially, but now that I'm working with it, there seems to be a hang-up...

Here's a sample...

You understood perfectly. Thank you very much, Grasshopper!

-DC Ross (always learning )

Thanks very much for the link, it was very informative (if not a bit above my head ).

I restructured my query based on...