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

I have a page where I am using a Text Filter to filter a long (15K) list of clients in a Business Data List web part. The filter works fine for All and for an entered name, so long as the full name is entered. It would be much more effective if I could allow the user to enter part of a name, especially if there is a doubt about how that name is spelled. I have tried to edit the Connection properties, in SPD 2010, to change the comparison to Contains from equals, which it is clearly defaulting to, but I do not get the option. I cannot believe that this is not possible, but perhaps not in SPD ? JK

share|improve this question
up vote 2 down vote accepted

This article by Phil Wicklund suits your requirements. It uses a dataview web part and a form web part to do wild card searching of the DVWP content.
It's geared towards 2007, but the principles apply to 2010.

share|improve this answer
Thanks Eric (n Phil). Good article. – JoeK Nov 18 '11 at 13:05
Anytime, it's a great article and gives users a lot of "search" functionality without having to roll custom scopes and the like. – Eric Alexander Nov 18 '11 at 13:24
The link to the article is not working anymore :( – Norbert Jan 1 '13 at 13:16

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.