SQL Server 2005. Full Text Search. Need Thesaurus working with NEAR/AND/OR keywords
- by user305924
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")'.