SQL Server 2005. Full Text Search. Need Thesaurus working with NEAR/AND/OR keywords

Posted by user305924 on Stack Overflow See other posts from Stack Overflow or by user305924
Published on 2010-03-31T10:49:18Z Indexed on 2010/03/31 10:53 UTC
Read the original article Hit count: 317

Hi, does anyone know if it's possible to do a thesaurus search together with NEAR or AND/OR keywords. Here is an example of the type of query I want to run:

    SELECT Title, RANK
            FROM Item INNER JOIN
            CONTAINSTABLE(Item, Title, 'FORMSOF(Thesaurus, "red" NEAR "wine")') AS KEY_TBL
            ON Item.ItemID = KEY_TBL.[KEY]
    ORDER BY RANK DESC

....But I get the error message:

Syntax error near 'NEAR' in the full-text search condition 'FORMSOF(Thesaurus, "red" NEAR "wine")'.

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about full-text-search