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..."