How to parse column data using select??

[nick sharma]

Hi
I have a small problem regarding parsing data in a column using only select statement

Say there is some data "abc;def;ghi;" in a column which needs to be displayed as

abc
def
ghi

using only select statement.

I know we can write a procedure to easily do this but i would like to know how it can be done using only select whether nested or inline.I tried using string functions but couldn't think of some logic to do it.

Thanks
Nikhil

[Campbell Ritchie]

Don't ask the same question twice. More details here. Closing topic.