2012年3月25日星期日

Full Text Search in SQL Server 2000

I'm having trouble retrieving results from a SP that uses the Contains
or FREETEXT functions.
CREATE PROCEDURE dbo.bugFuzzySearchDesc
@.SearchTerm varchar(2048)
AS
SELECT
issue_id,
issue_description
FROM
bug_issues
WHERE
FREETEXT(issue_description, @.SearchTerm);
/*CONTAINS(issue_description, @.SearchTerm);*/
The Parameter that gets passed to the SP looks like this:
'"Mercury*" OR "Midware*"'
The column being searched on has the following value in one particular
record:
"Setup Mercury Midware for Mercury Payment Systems"
Yet, the query returns no results.
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."Lee enlightened me by writing:

> "Setup Mercury Midware for Mercury Payment Systems"
> Yet, the query returns no results.
Never mind. I'm using a DB on our hosted website and they
re-index/re-populate the catalogs very 24hrs. Makes sense if it's an
expensive process...
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

没有评论:

发表评论