Question about FREETEXT query

I have the following query

SELECT * FROM ViewName WITH (NOEXPAND)
WHERE FREETEXT (*, 'wills') ORDER BY Column1, Column2

This returns 0 results (not what I'm expecting).

If I change the query to this (notice double quotes around search
term) it returns results:

SELECT * FROM ExpertWitness WITH (NOEXPAND)
WHERE FREETEXT (*, '"wills"') ORDER BY State, LastName

Can someone explain to a non-DBA what's going on here?

Thanks.
Mike
HardBap [ Do, 20 Dezember 2007 16:11 ] [ ID #1891351 ]
Datenbanken » comp.databases.ms-sqlserver » Question about FREETEXT query

Vorheriges Thema: Imitating ownership possible?
Nächstes Thema: Req: SQL Developer / DBA