how about this:

declare @FinalString nvarchar(250)

SET @FinalString=''

SELECT @FinalString = COALESCE(@FinalString + ', ', '') + (CAST([name] AS nvarchar(50)))

FROM Fruit

order by [name]

SELECT REPLACE(@FinalString,'''',' ')