Search Engine using SQL Stored Procs

<i><b>Originally posted by : Ajay (ajay@aimpro.co.uk)</b></i><br />How can I write a search engine which called an SQL Procedure that returns a recordset? Remember that people can type in more than one word within the input field..<br /><br />