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

> 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.

The question is not want you should write, but what you want to retrieve from the database. If you simply want to make the statement work, you could use MIN or MAX instead of SUM.

I think you will have more success with your question if you describe the underlying problem, and what you actually want to retrieve

Thomas

-- 
It's not a RootKit - it's a Sony