I setup Full Text Search on SQL Server and
created this stored procedure which works
in Query Analyzer when I supply it with one
string parameter:
SELECT name, desc
FROM Products
WHERE CONTAINS(*, @searchString)
For the code in ASP.NET, I need some way of breaking
the searchString into separate words so I can pass it into the stored procedure. Currently, if I pass "the" or "4" it returns an error because these are noise words. It also
creates an error if there is a space.
Is there any code or routine out there that has a function
that can handle this filtering and checking?
I'm guessing I'll have to play with string manipulations
until I get it right. I would like to limit the search
to 5 words.
thanks
created this stored procedure which works
in Query Analyzer when I supply it with one
string parameter:
SELECT name, desc
FROM Products
WHERE CONTAINS(*, @searchString)
For the code in ASP.NET, I need some way of breaking
the searchString into separate words so I can pass it into the stored procedure. Currently, if I pass "the" or "4" it returns an error because these are noise words. It also
creates an error if there is a space.
Is there any code or routine out there that has a function
that can handle this filtering and checking?
I'm guessing I'll have to play with string manipulations
until I get it right. I would like to limit the search
to 5 words.
thanks