[plug] Re: [OT] SQL column splitting

[Bernd Felsche]

James Devenish <devenish at guild.uwa.edu.au> writes:
>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.

Ewww yuk. Codd Rules. OK!

<sorry>
-- 
/"\ Bernd Felsche - Innovative Reckoning, Perth, Western Australia
\ /  ASCII ribbon campaign | I'm a .signature virus!
 X   against HTML mail     | Copy me into your ~/.signature
/ \  and postings          | to help me spread!