Question about FREETEXT query

Question about FREETEXT query

am 20.12.2007 16:11:54 von HardBap

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