I have a multi select field, which of course may have more than 1 selection. I want to know if the value "A" is selected, regardless of there being other selections made. If I use field = "A" or field IN ("A") I get the same result and that result is only the records where "A" is selected and no other selection is made. In other words, the records having both "A" and "B" selected are not in the results returned. I've looked and looked and can't seem to find how filtering on multi select list can be done to get what I want. This seems like the most basic type of filtering one would want to do on a multi select field type, but I can't find it.
