I am trying to write a CAML Query that returns all items from the list where in the "Title" field they contain "No Title". (In order to delete them later).
The deletion is done in Csharp.
I have come up with the below query:
<View><Query><Where><Contains><FieldRef Name='Title' /><Value Type='Text'>No Title</Value></Contains></Where></Query></View>
It there is one item containing "No Title" it works, returns one item. If there is several items containing "No Title", it only returns one item as long as the fields have the same string.
Is there anything missing to my query?