Melonie Poole
Melonie is the Director of Service Delivery for Catapult's Managed Services team.  She is also an MCITP for SharePoint 2010 and MOSS 2007 and blogs about Managed Services and SharePoint.

Wildcard Searches   

Tags: Workarounds, SharePoint 2007, SharePoint 2010
Technorati Tags: , ,

SharePoint 2010 will (FINALLY) include the ability to do wildcard searches. This is good news for those of us who aren't sure how a term might have been spelled when a document or page was created. Let's say, for example, that you need to track down a contract your company has with the restaurant Schlotzsky's. (I can never remember how to spell that but they have the BEST sandwiches!!) With wildcard searching, you can search for the first few letters, like "schlo". In SharePoint 2010, you do this by using an asterisk for the wildcard. You type, in the search box, Schlo* and you are returned results that include documents where the name includes "Schlo". Most users don't try wildcard searches but for those that do, this is a very nice addition.

So what about those of us still on SharePoint 2007? MOSS 2007 is, by the way, still one of the best web collaboration and publishing applications out there. And, for organizations that aren't ready or don't have the budget to upgrade quite yet, it's a good friend.

With some customizations and/or a custom web part, you can do wildcard searches. But you can also do a wildcard search with the basic, out-of-the-box functionality. You just need to know the name of the property. The two that are used most often are the name and title of a document – The name is Filename. The title is Title. Easy enough, right?

So here are two examples for what you type into the SharePoint 2007 search box:

  • Filename:schlo*
  • Title:schlo*


That's it. The results will include any items whose filename (or title, depending on which property you use) include "Schlo". If you want to do a wildcard search based on another property, check with your SharePoint Administrator who can provide you with exact property names to use.

SharePoint 2010 has several more search improvements which I'll be blogging about over the next few weeks. Until then, happy searching and Happy New Year!

Posted by  Melonie Poole  on  12/29/2010
2  Comments  |  Trackback Url  | 0  Links to this post | Bookmark this post with:        

Links to this post

Pingback from  How to customise SharePoint 2010 Blog Post | dev.notes.share()  on  1/26/2012  8:03 PM

Pingback from  How to customise SharePoint 2010 Blog Post | dev.notes.share()  on  1/26/2012  8:03 PM

Pingback from  Handy Table for Comparison of SharePoint 2010 Server and … |  on  3/5/2012  6:47 AM

Pingback from  Not much success | Scott Kilmurray's Blog  on  3/17/2012  12:16 AM


Michael Forst  commented on  Tuesday, June 14, 2011  5:28 PM 
Melonie, Having just installed SharePoint 2010 at Applied Materials, that is one feature everyone was excited about. However, we have noticed that it works great in the standard search, but are seeing issues in Advanced search. It looks to be removing the *. Have you noticed that?

Melonie  commented on  Thursday, June 16, 2011  10:46 AM 
Hi there, Michael (good to hear from you!).

I haven't seen this before but a quick test in my own environment mimics what you are seeing. I couldn't locate any official information from Microsoft about what's included OOTB for advanced search but I found a forum thread that indicates a custom solution is needed if you want to implement wildcard searches on Advanced Search -

Name *:

CAPTCHA Image Validation