Love the Split/Join functions, advice needed

I have a table with an id, varchar_str which is strings of comma-separated values. Using split/join/cursor I can retrieve the comma-separated values, but I need to retrieve the id and comma-separated values from the table. Any advice?