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