IN predicate & passing input parm to its stored proc.

<i><b>Originally posted by : B. Bora Bali (bora@sprynet.com)</b></i><br />Hi folks,<br /><br />I have a query like the following one. This is going to be placed in a stored procedure. <br />I want to pass an input parameter, that is determined in an ASP script, to the IN predicate <br />of the stored procedure's query statement: <br /><br /> SELECT text <br /> FROM table <br /> WHERE id IN (k_1, k_2, k_3, ..., k_n)<br /><br />I want to pass the set of k_x as an input parm to the proc. (Is this possible?) <br />Note: id is an integer. <br /><br />If possible, how would the stored procedure for this query look like? <br /><br />I really appreciate your inputs.<br /><br />(I am running MS SQL Server Version 6.5)<br /><br />-B. Bora Bali