[plug] Re: [OT] SQL column splitting

[James Devenish]

In message <20041115101826.GA11461 at mail.guild.uwa.edu.au>
on Mon, Nov 15, 2004 at 06:18:26PM +0800, James Devenish wrote:
> I want like to split
> ('1', 'A', 'x,y, z'), ('2', 'B', 'i')
> into
> ('1', 'A', 'x'), ('1', 'A', 'y'), ('1', 'A', ' z'), ('2', 'B', 'i')

Just to be clear about the sort of solutions I am after... The table
contains entries like 'x,y, z' because of the nature of its application.
Since ',' is a delimiter in this case, my problem is one of "converting"
the data to a more relational model. However, because circumstances
prevent this from being solved with a one-off migration, I would like
to be able to do it dynamically in SQL.