I'm using several multi-list fields in my searches, and they work great to say "field = value" and it finds a matching value in the list. What I need now, though, is to check if the value I'm looking for is the only one in the list.
Example: a multi-list of states. In the usual scenario, I want to check if Virginia has been selected. In this new scenario, I want to check if the list contains Virginia ONLY...if Maryland is also selected, for example, then the result would not be returned.
Is there a length value that could be checked to find out how many selections are in the field? Then it'd be easy to say "AND length = 1" in addition to my standard query.