do not repost questions.
you already asked simillar question here
^[
^]
as per basmeh Awad answer:-
select no,username,role1 +','+role2+','+role3 as ROLE from UserData
in case you need to combin a numeric data type with varchar datatype then you need to use this.
select no,username,cast(no as varchar)+','+role1 +','+role2+','+role3 as ROLE from UserData