Full Text Search . . need VB code

[MikeMCSD]

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

 

[peekay]

You might try using the instr() function in the SQL

PK Odendaal

http://www.odendaal.com