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

[Jeanne Boyarsky]

Nikhil,
I think you'll need the procedure (or database specific functions). Basic SQL doesn't have a loop function.