Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am trying to devlop a search function on a list. It is a parts list that has the following headings:-

Stock Number, Name, Colloquial

How can i search in any of the fields by partial parts of a word. eg in the "Name" field i would like to search for the word "Bolt" if the name text is 3/8 bolt. Sharepoint 2007

share|improve this question

2 Answers 2

you can use CONTAINS operator in CAML Query.

For e.g.

<Where><Contains><FieldRef Name='Name'/><Value Type='Text'>Bolt</Value></Contains></Where>
share|improve this answer

In SharePoint 2007 Search, if you look for filename:"Budget" (with quotation marks), your search will return files named “Budget” such as "Budget.xlsx." A search for filename:budget (without quotation marks) will also return that file and files named "Budget_Current.xlsx" and "Budget_Next.xlsx." Only prefix matching is allowed in property searches, which means that you must have at least the first letter of the property value to complete the search.

You can also use wildcard characters in property searches. Wildcard searches include characters, such as “*”, which allows the search engine to substitute any number of characters and “?”, which allows the search engine to substitute any single character. Prefix matching is also required when you use wildcard characters. This means that you cannot insert wildcard characters in the middle of a property value such as W*ton or at the beginning of a property value such as *ington.

There are several approaches and tools out there that you can implement to add wildcard functionality into SharePoint, and most of them are without cost or obligation.

• Ramon Scott has posted a walkthough on how to configure wildcard searches yourself in your SharePoint environment. Be sure to check out the post's comments for additional information and a link to another post Ramon wrote on the subject - http://www.ramonscott.com/wordpress/?p=8

• Corey Roth has contributed a free wildcard search add-on for MOSS to CodePlex. As with all CodePlex applications its support is going to be limited, but it is a full 1.0 release of the component and it appears that Corey is still making updates to the project - http://www.codeplex.com/WildcardSearch

• Ontolica Search offers a free wildcard search add-on, with no restrictions on its use. I don't know what kind of support they offer it, and you will have to provide them marketing contact information in order to download it, just as an FYI - http://www.ontolica.com/Ontolica%20for%20MOSS%202007/Ontolica%20Wildcard.aspx/

• There's also another project on CodePlex you can check out (tip of the hat to Paul Galvin for finding this): http://www.codeplex.com/SPWildCardSearch/

Reference

a. http://social.technet.microsoft.com/Forums/sharepoint/en-US/7061b8a3-31d1-4a9d-aa8a-8870e5a3ca12/how-to-enable-wildcard-search-in-wss30

Hope this helps you.

share|improve this answer

Your Answer

 
discard

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.