Advance Search webpart, contains is missing
Default the “contains” option is missing in the property select field of the Advance Search Webpart in SharePoint 2007. The reason for this is the hugh load on the SQL server if this option is used to query the SharePoint index. So be careful when adding this option.
Add following line
underneath root node in the Advance Search webpart properties XML.
- Go to Advanced Search page and click Site Actions, and Edit Page.
- On the Advanced Search Web Part, click Edit in upper right corner of web part, and then click Modify Shared Web Part.
- In the Properties text box, click the small rectangle Builder.
- In the Builder dialog box, under the root node create
and click OK