freetexttable bug

From: Baldwin <ibaldwinjr@xxxxxxxxx>
Date: Fri, 12 Oct 2007 15:15:41 -0000

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

.

Follow-Ups:
- Re: freetexttable bug
  - From: Hilary Cotter

Prev by Date: Re: Allowing the omission of 'AND'
Next by Date: Re: msftesql.exe uses 100% on all CPUs
Previous by thread: Allowing the omission of 'AND'
Next by thread: Re: freetexttable bug
Index(es):
- Date
- Thread

Relevant Pages

Re: Finding OpenVMS Programming Examples in HPs Natural Language Search Engine
... > mostly matching the query on following pages. ... However the search engine ... > is still substituting my keywords with synonyms. ...
(comp.os.vms)
SQL 64bit SP4 - Server: Msg 7342 - Unexpected NULL value returned
... following error while doing a CONTAINS query on a fulltext catalog. ... DB provider 'Full-text Search Engine'. ... I have tried to rebuild the catalog, ...
(microsoft.public.sqlserver.fulltext)
freetexttable bug
... We've been using the catalog as part of our search engine for a year ... We use freetexttable to search for keywords and it is fine until ... I tried this query and I got a lot of rows. ...
(microsoft.public.sqlserver)
one more sure teenage harmonys will differently grasp the bargains
... Sounds like the search engine I just used. ... You give the search engine keywords to search for, ... and personal messages that the station catches. ... The computers automatically search through everything as it arrives at the ...
(sci.crypt)
Re: The sense of it search engine
... Have you any ideas on how you might implement such a search engine, ... more effectively as an idea rather than as some keywords. ... "The land shall not be sold in perpetuity, for the land is mine; ... the Google search "land caretaker Bible", not an unreasonable one to use. ...
(comp.lang.java.programmer)