I have 4 fields named Sub-Category1, Sub-Category2, Sub-Category3, and Sub-Category4
I would like to create a query that searches for all tests that contain the string "Parsers" in ONLY 1 of those 4 fields. That is, any test containing the string in only 1 of the fields above will appear in the output list. However, any test containing the string in more than one of the 4 fields will not appear.
That requires an "interesting" and very ugly SQL query! It involves a lot of ANDs and ORs (I count 3 ORs and 12 ANDs) using "LIKE" and "NOT LIKE" and since I'm not in a position to test what I write, I'm not going to draft it for you.
I've usually broken up complex queries into smaler ones used through out a subroutine or function to populate output lists. This not due to me feeling they are too complicated to make, (although I have to agree with Peter that the condition you listed is a doozy) but I have to think of the other people that will end up supporting after me. I'm pretty sure they are going to be pulled from a pool of employees who aren't as technical as they need to be.