CAML query case sensitive search

Question

I have a caml query which is pulling data from sharepoint list

Here is the query I am using

tempQuery = "John"+CURRENT_USER_Info.currFilter+"";

The problem is I have search only for John and not john or JOHN

so basically looking for a caml query which can filter case sensitively..

Any help is appreciated.

Answer 1

There is no option for case sensitivity in caml queries. You must filter the results secondary for case sensitivity.

Answer 2

It is true that straight CAML queries are case-insensitive, but you may be able to use LINQ to SharePoint to get to what you're trying to achieve.