Converting result set into string

[Stefan Tister]

I would like to convert a result set from a select statement into a string to insert it into another table in an excel style like:

update tableA set colA = (select colA, colB, colC from tableB where id < 10) where id = 1;

after the update colA should look like:

valueA,valueB,valueC;valueA,valueB,valueC;valueA,valueB,valueC;

is there any string function which concats the several rows from the result set into a string??