We really should be able to query this way and not have to do a crazy series of or statements with dozens of parenthesis. I should be able to do analysis this way, such as run demographic and statistical reports without having to pick either county or state to show! I want both! If counties were exclusive (i.e. there is only one suffolk county - then I would be fine but there are suffolk counties in multiple states! I have been suggesting this for MANY years and this really needs to happen.
Hi - there is a suggestion to revamp the whole address hierachy which would help resolve your problem
http://rediscovery.uservoice.com/forums/137015-raiser-s-edge-discovery-topics/suggestions/2693843-revamp-address-management