Post reply

SQL Contains Statement Question

  • April 24, 2009 at 8:54 am

    #131514

    I am running the following sql statement and when i substitute "sap" or "abap" for "c" or "c#" i do not get any results, even though i have FTI on the documents and they contain "c" and "c#".

    Any ideas ?

    Thanks

    where (contains (resnar, '"sap"

    and "abap"'))

  • May 13, 2009 at 5:47 am

    #993587

    Single characters and most symbols are excluded from full-text indexing. Most of them are listed as "noise words" (look them up in Books Online) and are listed in noise-word files of the given SQL Server instance.

    You can edit the file(s) and remove any strings that you do not want to be excluded from indexing. In fact you can also replace the contents of the file with a single space, which means there won't be any exclusions.

    Warning: Make sure you edit the correct file (there is one per each supported culture, and a generic one) and each instance has its own set of files. The location of the noise files is documented in Books Online.

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

  • May 13, 2009 at 5:50 am

    #993589

    Thanks!

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

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