Is it possible SUM(STRINGCOLUMN) ????

Hi,

[Quoted] Let say i have the following table

Table ABC

COL1    COL2        COL3
1                2                'AA'
1                2                'BB'
1                2                'CC'
1                2                'DD'

select Col1, Col2, SUM(COL3)
from table ABC
group by Col1, Col2

And that will return

COL1    COL2        COL3
1                2                'AABBCCDD'

I know that the previous example is not possible but does anyone know a way to achieve that ??? Received on Tue Feb 13 2001 - 14:19:17 CET