Transact-SQL - FreeText

Hi

I was looking at this link :

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=792720&SiteID=17&pageid=0

I am using SQL SERVER 2005.

I have noiseeng.txt and noiseenu.txt.

I have stopped all the MSSQLSERVER, MSSQLAGENT,BROWSER, EXPRESS and FULL SEARCH.

Then I removed all the numbers from the noiseeng.txt and noiseenu.txt.

I restarted the services again.

I tried to run this query

DECLARE @SearchWord nvarchar(30);

SET @SearchWord = 'MS';
SELECT ProductDescription
FROM Products
WHERE FREETEXT(ProductDescription, @SearchWord);

I can't seem to get any records out and it won't pick the following that I am actually looking for.

In the Products table, it has several rows containing:

MS1234
MS_1234
MS-1234
MS 1234
MS/1234

I am trying to retrieve the above records using just 'MS', but it just doesn't work at all.

Well using SQL Server 2005, FREETEXT or CONTAINS is more powerful than LIKE. Cos potentially we have thousands and thousands of records. So FREETEXT/CONTAINS is faster and more efficient.

Any suggestions, help or examples please - would be most appreciated.


Thanks

Newbie

What is the minimum word length set on your free text index(es)?