SQL question: GROUP BY: Is there a "SUM" for strings?

Hello,

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 VARCHAR2 (doing string concatenation instead of addition)?

I'm still on Oracle 8.1.6.3.

Thanks for your help
W. Roesler Received on Tue Apr 25 2006 - 05:17:22 CDT