Hi All I'm trying to create a aggregate function similar 9but not identical) to mysql's group_concat. What I want to be able to do is pass and order by field to the aggregate so I can be certain I get the list of strings in the correct order. Does anyone have any ideas how this could be done? In a previous thread on aggregates a couple of people said that they thought it was doable but nobody hinted at how. Thanks in advance Charlotte Pollock ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend