0

I have a text e.g AOCup and i need it to match AO Cup

Where currentsite variable below is = AOCup but what im querying is AO Cup

Thanks in Advance

** I also used Contain with no luck

 <Query><Where><BeginsWith><FieldRef Name='Title'/><Value Type='Text'>" + currentSite + "</Value></BeginsWith></Where></Query>
1

you can try using below query:

<Query><Where><Contains>
     <FieldRef Name='Title' />
     <Value Type='Text'>AO</Value>
  </Contains></Where></Query>
1
  • Thanks Hardik but i tried using just contain and had no luck – naijacoder Sep 17 '14 at 12:44
0

there is no such thing as like in caml queries but you could try it with an AND connection and a condition, something like this:

<Query><Where><And><Contains><FieldRef Name='Title'/><Value Type='Text'>" + AO + "</Value></Contains>
<Contains><FieldRef Name='Title'/><Value Type='Text'>" + Cup + "</Value></Contains>
<And></Where></Query>
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.