Posted by HardBap on 12/20/07 15:11

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

[Back to original message]