Question about FREETEXT query
am 20.12.2007 16:11:54 von HardBapI 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