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

• Next in forum: Re: Imitating ownership possible?
• Prev in forum: Re: SQL2005: Running TSQL commands in single-user mode
• Thread view: Question about FREETEXT query

[Reply to this message]