try this
select no,username,role1 +','+role2+','+role3 as ROLE from UserData
in case you need to combine 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