SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column.

It basically does not work, the Equal works though.

here is the query, nothing special ...

         <FieldRef Name='MyLookupOnACalculatedField' />
         <Value Type='Text'>some value</Value>

Anybody else has the same issue ?


share|improve this question
can you paste the code? – Falak Mahmood Jun 27 '12 at 11:39
added to the original. This query works on a calculated field but does not work if this field is a lookup on a calculated field. – GillouX Jun 27 '12 at 12:46
Wow, I just ran into the same issue. Have to tell them to not use a calculated field, not many other options – steven iseki Mar 10 '15 at 1:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.