St.procedure for wide search by some key words

Hello, all.
I have an asp code which allows user search for necessary Items
in the table by typing in some key words using space as separator
in "description" text field. Using VB and dynamic SQL I create an array
from Request.Form("description") by separating words by space than in
Loop I generate necessary SQL statement to open recordset.
Now I have to replace it with stored procedure to do the same thing -
search for Item using some key words (never know how many) from
its description.
Any suggestion?

Thanks in advance.