Subject List function, how to sort (FB 2.1)
Author rj1102
Dear all,
I like the new list function in FB 2.1.0.
But how do I sort the values within the list result?

I've tried an embedded select:

SELECT MyField1, List(MyField2)
FROM (SELECT MyField1, MyField2 FROM MyTable ORDER BY MyField1,
MyField2)
GROUP BY MyField1

But this gives the same result as:

SELECT MyField1, List(MyField2)
FROM MyTable
GROUP BY MyField1

Kind regards,
Robert