String aggregate function

Hi all,

I want to make an aggregate function that concatenates strings from a
certain column into one cell in a group by clause.
For example I have the following table :

Type        Text    
=================    
1        text1
2        text2
1        text3
3        text4
2        text5

I need a query that group by type and concats the text columns to
produce something like the following :

1        text1, text3
2        text2, text5
3        text4

I am aware that this can be done through recursive joins but this is too
complicated and heavy.

Any suggestions?

Regards