Fulltext Search

Apologies if this is not the correct place to put this.

I wrote this query to perform a fulltext search on tblPages.

SELECT * FROM tblPages,
FREETEXTTABLE(tblPages, *,@.searchTerm) searchTable
WHERE [KEY] = tblPages.PageID ORDER BY RANK DESC

Where PageID is the primary key.

The synax is correct but why does it never return any results?

thanks

marc"Marc" <marc.birkett@.gmail.com> wrote in message
news:1120751900.865752.25890@.o13g2000cwo.googlegro ups.com...
> Apologies if this is not the correct place to put this.
> I wrote this query to perform a fulltext search on tblPages.
> SELECT * FROM tblPages,
> FREETEXTTABLE(tblPages, *,@.searchTerm) searchTable
> WHERE [KEY] = tblPages.PageID ORDER BY RANK DESC
> Where PageID is the primary key.
> The synax is correct but why does it never return any results?
> thanks
> marc

I have no idea - does SELECTing only from FREETEXTABLE return any results?
Without seeing table DDL and data, it's almost impossible to say, so you
should probably put together a script which others can run in Query Analyzer
to reproduce your problem. You might want to post to
microsoft.public.sqlserver.fulltext, as you may well get a better response
there.

Simon|||No it doesnt! Found microsoft.public.sqlserver.fulltext.

thanks for the advice.