Contains CAML query returns only DISTINCT items

Question

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?

Answer 1

The CAML looks ok. Maybe it is your C# code that is causing the trouble. Have a look at the sample code here.

Answer 2

Try using following code in your query:

"<Where><IsNull><FieldRef Name='Title' /></IsNull></Where>"

Please upvote if this answer helped you in any way.