I've a query that goes like this:
<In> <FieldRef Name='Industry'/> <Values> <Value Type='Text'>Insurance</Value> </Values> </In>
I would expect it to be equivalent to this:
<Eq> <FieldRef Name='Industry'/> <Value Type='Text'>Insurance</Value> </Eq>
But the first one returns 3 results and the second one around 400. Also, the column i'm querying against is a Choice one. If I add one value to that column and then remove it, it stops to appear in the first query. Am I missing something? Does In operator works as I supposed?
And, is there any reason for my result to stop appear in my first query after I modify the column? (It keeps not appearing even when I remove the new element, so it's as it was before)