OK, what you're looking for is a function to split a comma-separated list into its individual components. You should be able to find one by searching this site for "splitter function" or something like that. Once you have one of those, you can CROSS APPLY the results against your table to get the output you desire.

John