FREETEXT - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

FREETEXT

Author

Topic

clive cauchi
Starting Member

2 Posts

Posted - 2012-05-03 : 05:45:14

hi,

i have the below sql statement:
SELECT *
FROM Products p
WHERE FREETEXT(p.*, 'spoil')

this statement should return 2 rows since i have 2 words which shave the phrase 'spoil' in them. but i am getting null rows everytime. on the other hand, if instead of 'spoil' i write 'spoiler', 1 rows will appear (since i have 1 row which have the word 'spoiler' in its description).

can anyone pls help me solve this problem and maybe tell me what i am doing wrong?

thanks in advance

Thanks
Clive

vinu.vijayan
Posting Yak Master

227 Posts

Posted - 2012-05-03 : 06:30:55

Full Text Search on its own will not work according to the requirement you have. Following link shows what Full Text Search does:

[url]http://msdn.microsoft.com/en-us/library/ms142571.aspx[/url]

You are trying to make Full Text search work as "Wildcard"....that is possible by using "Contains" with Full Text Search. This is how you can do it:

[url]http://blogs.msdn.com/b/sqlforum/archive/2011/02/28/forum-faq-how-can-i-perform-wildcard-searches-in-full-text-search.aspx[/url]

N 28° 33' 11.93148"
E 77° 14' 33.66384"