Can the SUM keyword in SELECT be generalized to strings?

A tipical use for the SUM keyword is:

    SELECT column1, SUM(column2)
    FROM table
    GROUP BY column1

This works only if column2 contains numbers (and SUM is the mathematical 

What about obtain the same behaviour, when column2 contains strings (and 
SUM is string concatenation)?

Anyone help me please?
Thank you

Mauro Boscarol

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to