Hi -
I am trying to concatenate a text field in a query with a group by clause, similar to a sum() function on a numeric value - for example:
SELECT groupid, sum(numeric_field), ???(text_field) FROM table GROUP BY groupid
but I cannot find a function that will concatenate the text fields. Any comments appreciated!
TIA,BGH