how to select value when have multiple value in single colum

Try the below query

declare @str varchar(1000) 
select @str= coalesce(@str + ', ', '') + dob.Tbl_Products.ItemCount  from dbo.Tbl_Products 
inner join  dbo.tbl_size on tbl_size.sizename=Tbl_Products.sizename 
where ProductName='xyz
print @str

have a look of the link for detail understanding


http://www.c-sharpcorner.com/blogs/how-to-select-column-values-as-comma-separated-string-in-sql-server1
http://www.codeproject.com/Tips/635166/SQL-Column-Values-as-Comma-Separated-String
http://stackoverflow.com/questions/21760969/multiple-rows-to-one-comma-separated-value