Question
· Sep 30

Combine all rows in select into one comma delimited string

I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example:

 

SELECT First Name

FROM mydb.People

 

I get a list of names:

John

Fred

Sarah

Carl

Jane

Julie

 

Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie"

 

Is there a way to do that?

Product version: Caché 2018.1
Discussion (2)1
Log in or sign up to continue