FOR XML PATH

droptable test

create table test (pos varchar(4), str varchar(10))

insert into test values ('1','hello'), ('1','yes'),('1','No') select * from test

SELECT stuff((SELECT ', ' + str FROM test WHERE pos = '1' FOR XML PATH('')),1,2,'')