the XML solution can also be:

select replace(

convert(

varchar(max),

(select name+',' as [text()] from fruit order by...