concat function for strings
I have this problem:
Within a group you have a column of string
values-Say states for example on a group summary
line you want a concatenation of the string state
values for all rows in the group.
so you might have
ID State
1 AZ
1 AL
1 MO
Summary group footer:
1 AZ, AL, MO
This is a little similar to the "running total"
idea but instead of adding numbers I want to
concatenate strings together.
Thank anybody for any idea. Frank
|