sql server full text search: freetexttable issue -- sql server full text search

freetexttable issue

ibaldwinjr NO[at]SPAM gmail.com
7/19/2007 12:00:00 AM

sql server full text search:

Hi,

I am using freetexttable as a search tool for our application but it
seems that it is partially working. I am able to search on some words
specified in my catalog but not on others. For example I got keywords
- stamps business cards. The freetexttable function can pick up only
'stamps' but not 'business'. I created another record in the table
included in the catalog and have the same keywords. Now I can search
on 'stamps' of the first record but not on the second record.

here is the code snippet:

select * from freetexttable(<table name>, *, 'keywordhere')

where: tablename is included in the catalog
keywordhere is the keyword in which i use 'stamps' or
'business'.

Any help is greatly appreciated.

thanks!
Baldwin

Re: freetexttable issue

Hilary Cotter
7/19/2007 3:14:08 PM

Can you try this

select * from freetexttable(<table name>, *, 'Stamps')

select * from freetexttable(<table name>, *, 'business')

select * from freetexttable(<table name>, *, 'Cards')

Do the same rows show up?

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]