Posted on 2003-11-12
Is there a way you can concatenate string together in a group.
select max(string) from table group by KEYFIELD
but I want to return a string list separated by ","
like 'XXX', 'XXX' for key field.
I can do it using a cursor, but can we write a function so it can be returned