The easiest solution is probably to use a second recordset. Then you can use the IN operator to return all of the rows like:
SELECT * FROM TableName WHERE ColumnName IN (param)
Then add your param and set it to type: Integer List and bind it to the first recordset that has the comma separated values.