Post reply

Contains() won't search certain words

  • June 24, 2009 at 12:10 pm

    #132194

    When I do a Contains(table, column, "on") it won't find any instance of the word "on." It works fine for other words so I'm wondering if "on" is interpreted as a SQL syntax and not as a string.

    Is there some sort of list of words that don't get searched? What can be done about that?

  • June 24, 2009 at 12:15 pm

    #1014839

    yes, there is a file that contains all the "noise" words that will be ignored.

    on my dev machine, you it is named "noiseENG.txt or noiseENU.txt , and resides in the folder named C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData

    you can remove the noise words that are really affecting you, but they are removed due to other peoples experiences.

    similarly, there are thesaurus files int eh same folder, so that you can make searchs for "camero" or "z28" find "Pontiac" and stuff like that.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 24, 2009 at 1:07 pm

    #1014867

    Thanks!

    Works great.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply