FREETEXTTABLE with Search Operators
Hi,
DB: SQL Server 2005
I'm trying to build in search functionality into my app using FreeTextTable (because it allows searching accross columns and provides ranking).
I'm having difficulty working out how to specify the AND search operator.
E.G. 1
Code:
...
-- Or Search, which works
LEFT OUTER JOIN FREETEXTTABLE(People,(Interests,Comments,Key_Phrases),'sheep calvin') AS Rank
...
E.G. 2
Code:
...
-- AND Search, doesn't work
LEFT OUTER JOIN FREETEXTTABLE(People,(Interests,Comments,Key_Phrases),'sheep AND calvin') AS Rank
...
Any ideas or alternatives will be gratefully received
Regards Al
Re: FREETEXTTABLE with Search Operators
Re: FREETEXTTABLE with Search Operators
Unfortanately that doesn't work says syntax error or something, sorry I'm not at work at the moment and can't recall the exact message.