Get items from sharepoint list by Title field with ignore care using Caml or SPQuery
I want to get data from SharePoint List using CAML and filtered 开发者_运维知识库by Title with ignore case like
<Query>
<Where>
<Eq>
<FieldRef Name='Title' />
<Value Type='Text'>Car</Value>
</Eq>
</Where>
</Query>
But with ignore case so if i have an item with title: car
the caml should return it
how can I do this?
I found out it's ignoring case by default.
精彩评论