How do I match an exact number using SharePoint search

Question

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.

Answer 1

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

Answer 2

Phrase search example:

SELECT <Columns>
FROM Scope()
WHERE FREETEXT(defaultproperties, ' "a few words" ') 
ORDER BY Rank Desc

Exact matching on numbers should also work with the FREETEXT predicate. See this blog post for more information on working with full-text queries.

Answer 3

When I had to find a specific date using FullTextSqlQuery and for example search for TimeStart = '2009-01-23' I used the following workaround : I use ( TimeStart >= '2009-01-22' ) AND (TimeStart < '2009-01-23' ) as search criteria. Is seems to work in my case.

And if you use SQL Server 2005 Express Edition please upgrade to Server 2005 Express Edition with Advanced Services. This will "Issue full-text queries against plain character-based data in SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase." according to MS

Answer 4

This was fixed by upgrading to WSS SP2 and MOSS 2007 SP2