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

Frank van Bortel <frank.van.bortel_at_gmail.com> wrote in news:e2kv13$5ej$1 @news3.zwoll1.ov.home.nl:

> Sum strings?!
> SQL Server background, where concatenation is done with '+'?

No :)

> In Oracle it's '||' - two vertical bars

Yes, thanks, but it won't work with GROUP BY, just like '+' doesn't for numbers. Look at my example: What should I write instead of SUM if colname was a VARCHAR2? As it seems, however, there's no easy solution.

Thanks anyway
W. Roesler Received on Wed Apr 26 2006 - 02:01:20 CDT