Convert Columns into comma seperated row

DECLARE @Role VARCHAR(max)

SELECT
@Role = COALESCE((@Role + ','), '') + LTRIM(STR(Role_ID))
FROM
Member_Role Where MemberID = 1

SELECT @Role

Above SQL generates the comma separated row.