Use XML Path In SQL Server

SELECT  SUBSTRING(( SELECT DISTINCT ( ',' + Email )
                    FROM    TableName
                  FOR
                    XML PATH('')
                  ), 3, 1000) AS EmailList