Create a table valued function that returns the delimited string as a column in a table. Join whatever table you are working on to this table (valued function) on the key columns.