How do I transpose or concatenate strings from a column output into a single row?

[sanjus]

I want to take a column from a table like this:

select * from Color;

Color
------
red
orange
blue
green

And return a resultset like this:

Colors
-------------------------
red,orange,blue,green

 

[medu]

you can't do that without using cursors and imho this is not something you'll want to do in Progress SQL... why don't you do that on the client side?

 

[sanjus]

Thanks m.edu.

That's what I ended doing - using a stored procedure (for cursor processing) which updates a view with the transposed record set.