FREETEXTTABLE with Search Operators

[aconybeare]

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

...
-- Or Search, which works
LEFT OUTER JOIN FREETEXTTABLE(People,(Interests,Comments,Key_Phrases),'sheep calvin') AS Rank
...

E.G. 2

...
-- 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

[MaximilianMayrhofer]

'sheep' AND 'calvin' ?

[aconybeare]

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.