Re: freetexttable bug

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Oct 17, 7:27 am, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
duh silly me. You need to remove AT from your noise word list and then
rebuild your catalog.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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

Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote in message

news:enGf5gGEIHA.4772@xxxxxxxxxxxxxxxxxxxxxxx



I've repro'd this. It could be by design, I'll raise it internally and see
if it is a bug.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
"Baldwin" <ibaldwi...@xxxxxxxxx> wrote in message
news:1192202141.265102.33850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

We've been using the catalog as part of our search engine for a year
now. We use freetexttable to search for keywords and it is fine until
now. For some reason the 'freetexttable' is inconsistent.

I tried this query and I got a lot of rows.
select * from tb_catalog
where content like '%AT&T%'

When I try this, I dont get anything.
select * from freetexttable(tb_catalog, *, 'AT&T')

But when I try this, I got rows.
select * from freetexttable(tb_catalog, *, 'SB&C')

So I thought it is just an ampersand issue but it worked in the last
query.

Any thoughts are really appreciated.

Great Thanks,
Baldwin
MISICompany- Hide quoted text -

- Show quoted text -

Thanks for the reply. But I dont think I want to do that. If I removed
the "AT" from the list of noise words, I can now search for "AT".

The other thing is, is the "&" was converted to space or something
that the search engine now is looking for "AT" and "T" but both are
considered as noise words thus not returning anything as oppose to
considering the AT&T as one word. take note that there is no space
between letters - "AT&T". is there a way we can use an escape
character for "&" so the search engine will consider AT&T as one word?

thanks really for the help.
Baldwin

.

Relevant Pages

  • Re: freetexttable bug
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Integration of Lucene.Net and SQL Server 2005?
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"DC"; ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Noise Words problem
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... Do you mean i remove noise words under C:\Program Files\Microsoft SQL ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable bug
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... We've been using the catalog as part of our search engine for a year ... I tried this query and I got a lot of rows. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: "IS" vs. "is" / important acronyms
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... do this for any capitalized word, as it's probably an important acronym to ...
    (microsoft.public.sqlserver.fulltext)