SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

A rather strange request has appeared from our client, who wants to be able to search a SharePoint 2010 list for items (based on a string column) while ignoring diacritics.

A quick example, assuming this is a list with IDs and two columns:

1. Paweł | Marciniak

2. Pawel | Jankowski

then searching the first column for PAWEL (or PAWEŁ for that matter) should return both items.

Can it be done using CAML?

share|improve this question
up vote 1 down vote accepted

AFAIK it's not possible using CAML alone.

But you may create an extra hidden column FirstNameNormalized, and update that with an EventReceiver on ItemAdded/ItemUpdated using a nomalized string like the one from Stripping is an interesting job.

Then when you're filtering you can do that on FirstNameNormalized using a likewise normalized string.

share|improve this answer
That was my initial idea, but I was hoping there was some way of making CAML do the work for me. Thanks for the answer. – Shaamaan Oct 22 '12 at 7:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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