stored procedure to return a subset of rows

[Mike McPherson]

how do I return a subset of rows from a select statement/
a simple filter won't work
One of the field is a comma separated list of groups
Input parameter is a comma separated list of groups for this user

I only want to return the rows where any of the user groups match any of the row groups

I'm ok doing the filtering, but how do I return only the rows that match (or skip the ones that don't)?

I thought about writing the good rows to a temporary table, but is there a better way?
thanks