We walk in the dark places no others will enter
We stand on the bridge and no one may pass

DECLARE @T TABLE (MyChar VARCHAR(11))

INSERT INTO @T
SELECT '0' + CHAR(10) + CHAR(13) + CHAR(9)
UNION ALL SELECT '6' + REPLICATE(CHAR(10) + CHAR(13) + CHAR(9), 3)
UNION ALL SELECT '8   '

;WITH Tally AS (
        SELECT n=number
        FROM [master].dbo.spt_values Tally
        WHERE [Type] = 'P' AND Number BETWEEN 1 AND 11),
    Codes AS (
        SELECT MyChar, [LEN(MyChar)]=LEN(MyChar), [DATALENGTH(MyCHAR)]=DATALENGTH(MyCHAR)
            ,n, [ASCII]=ASCII(SUBSTRING(MyChar, n, 1))
        FROM @T
        CROSS APPLY (SELECT n FROM Tally WHERE n BETWEEN 1 AND LEN(MyChar)) a)
SELECT MyChar, [LEN(MyChar)], [DATALENGTH(MyCHAR)]
    ,[ASCII]=STUFF((
        SELECT ',' + CAST([ASCII] AS VARCHAR(3))
        FROM Codes b
        WHERE a.MyChar = b.MyChar
        ORDER BY n
        FOR XML PATH('')), 1, 1, '') 
FROM Codes a
GROUP BY MyChar, [LEN(MyChar)], [DATALENGTH(MyCHAR)]