Help with full-text search

[leha2000]

MSSQL server database contains the projects table that allow full-text
search.

I search projects with name that contains exact phrase 'Project 2':
SELECT * FROM projects WHERE CONTAINS(projec ts.name,
N'("Project 2")'))
but results contain projects with names "Project 1", "Project 2",
"Project 3"

What is correct 2nd CONTAINS() function parameter for searching
"Project 2" only?

[Simon Hayes]

Re: Help with full-text search

According to Books Online, it looks as if you just need this:

CONTAINS(name, "Project 2")

But I don't really know - you might get a better answer in
microsoft.publi c.sqlserver.ful ltext. I suggest that you try to include
a script which reproduces your problem, and also the MSSQL version and
servicepack that you're using.

Simon