Why not just force formatting as you need it to be

SELECT CAST([Column1] AS VARCHAR(50)) + ',' + CAST([Column2] AS VARCHAR(50)) + ',' + CAST([Column3] AS VARCHAR(50))

FROM [Database].[dbo].[Table]

Will return Text1,Text2,Text3