R – How to match an exact number using SharePoint search

numberssearchsharepoint

In SharePoint (MOSS 2007) search, I need to match an exact number such as 2009482842 and nothing else.

How do I get search to only return hits on the exact number?

Edit: I originally thought this was only with the SQL FullTextQuery from code, but it is also a problem when searching from the portal itself.

Edit: This was fixed by upgrading to MOSS 2007 SP2.

Best Answer

Are you looking for the FREETEXT Predicate?

Example:

SELECT {columns}FROM Non_Portal_Content..Scope()
WHERE FREETEXT(defaultproperties, 'SEARCHSTRING')
ORDER BY "urn:schemas.microsoft.com:fulltextqueryinfo:rank" DESC
Related Topic