Get the Table Column data in a single row with comma separator in SQL

explaining how to get one column data in a single row with comma separator.

by sql function in sql- 2005/sql- 2008


Create Table  tbl_Mail_ids Contains email_ids




CREATE TABLE [dbo].[ tbl_Mail_ids](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Email_ID] [nvarchar](150) NULL,





Create Function Get_Emails That return email ids in single row seperated by comma

ALTER  FUNCTION [dbo].[Get_Emails]
(
@id int 
)
RETURNS nvarchar(4000)
AS
BEGIN

declare @email_list Nvarchar(Max);


With MyCte AS(


SELECT    ' '+ Email_ID
FROM         tbl_Mail_id
)
select @ email_list =
stuff(( 
select  email_list  +'# '  from mycte
for xml path('') ),1,1,'') ;

  Set @email_list  =  REPLACE(@email_list , '#', ',') 

RETURN   @email_list 


END
Execute function  >> select dbo.Get_Emails()