STUFF() Function XML or HTML in SQL Query

 alter proc Call_Meeting_SMS

as

begin

 SELECT distinct

    MobileNo = 

    STUFF (

        (SELECT  ',' + MobileNo  

        from login where Role  in  ('Record Keeper', 'Board', 'Accountant','Legal Advisor','CLERK','Dispatcher','Enquiry Officer Add','Enquiry Officer','Appealt Officer','CEO','Chairman')

        FOR XML PATH('')), 1, 1, ''

    )

FROM login GROUP by Id

end

Example