Hi all, I'm looking for a function similar to sum for char data fields. situation: table faecher (pnr int, fach char(20)) content of faecher: 1, 'Mathe' 1, 'Bio' 2, 'Deutsch' 2, 'Geo' 2, 'Sport'
For some reports we generate from our tables we need a representation of fach for equal pnr in one string in the following manner: 1 => Mathe Bio 2 => Deutsch Geo Sport For numerical values of the table I could just use SELECT pnr, sum(fach) FROM faecher GROUP BY fach But how can it be done for char. For this example I have simplified the table, we use keys instead of fach as char(20). Any Help ? Thanks Elke _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
