ok tricky and odd.
The project I am taking over well, the previous guys did a horrific job.

Basically, we have records of tracks and each track is suitable for a particular occasion.

there are multiple occasions.

What they did was for each track, they put in the "occasions" field, multiple occasions with a # dividing the occasions.

What I want to do is, if an occasion has say:

Wedding#Funeral

it means the track can be played at a Wedding or Funeral.
Since the records are doing an inner join in the SPROC, is there a way I can split that record so it brings back the same track but for the seperate occasions for both Wedding and Funeral?