SUM-Function for strings, to concatenate strings

[Liz Helmecke]

Hello NG,
is there something like SUM, but for strings?

I can do

SELECT SUM(colname)
FROM mytable
WHERE whatever
GROUP BY whatever;

to sum up numbers of a group, but:

how would I do this if colname was a STRING
-> doing string concatenation instead of addition !

the only way I found was to write my own function and use it in the query.
Is there an easier way?

Thanks for your help
Liz

 

[Douglas J. Steele]

AFAIK, yes, the only way is to write your own function.

 

[Duane Hookom]

Or, use someone else's function. There is a possible solution at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.