On 8/31/07, Acm <alextabone@xxxxxxxxx> wrote: > and I want one result to be "Mike,John,Dennis". SELECT ARRAY_TO_STRING(ARRAY(SELECT * FROM PEOPLE),',') AS FOO ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings