comma delimited to cols

[vlitim76]

I havea table that looks like:

id name status
1 new new,new-rd,hold
2 open open,open-rc

and I want to get it out like

id name status
1 new new
1 new new-rd
1 new hold
2 open open
2 open open-rc


sure I have done this before but can't remember how!?

Cheers

Tim

 

[gmmastros]

This thread (thread183-1243232) is similar to what you are trying to do. Take a look at it. Try to implement it. If you have any followup questions, then post back here and we'll help more.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[vlitim76]

absolutely perfect, thanks for the pointer.