Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Thesaurus not working with NEAR keyword
2 views
Skip to first unread message
Enoch
Mar 30, 2010, 10:14:43 AM3/30/10
to
Hi, does anyone know if it's possible to do a thesaurus search
together with NEAR or AND keywords.
Here is an example of the type of query I want to run:
together with NEAR or AND 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")'.
0 new messages