I would like to pass a list of ids to my stored proc for use in a statment like:

SELECT pr.name where pr.id IN ('23,25,27&#39 FROM profiles pr

so that the list following the IN statement is a replaceable parameter. How do I declare the parameter in my stored procedure?