Hi Jmodic,

Really you guys are great. Your solution is great but still it's not working completly.

In the table i have values like this

harry peter
mag b boston
Keith warn

your query output is

COL_1 COL_2 COL_3
-------------------- -------------------- --------------------
harry peter
mag b bos boston
Keith warn

That bos is repeting. And if i have another value
like
"ben j sam jr" then i want to break into 4 columns.

Sorry, I know that i am giving trouble to you guys. But this is a big problem to me. So please don't take me bad.

Thanks Jmodic and stecal.