Still don't know how to build this string ?

Hello there

I have still the same problem. Any help would really be appreciated !
Thanks ... jr

Is it possible (and I think it is) to do the following :

I have a table with diameters and types. I need to build a comma separated
string.

typ diam
01 800
01 840
01 870
01 1120
02 760
02 780
02 800
02 900
03 1200
03 1234
03 1352

select diam from zylinder where typ='01'

should produce the string "800,840,870,1120"

============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================