how to select value when have multiple value in single colum

Question

how to select value when have multiple value in single column

 

 

i want select value and single column have values like: [A,B,C,D] 

 

select * from dbo.Tbl_Products inner join dbo.tbl_size on tbl_size.sizename=Tbl_Products.sizename where ProductName='xyz'

 

for example in this product name  ProductName='xyz'

 

size have a,b,c,d,

 

then it show one bye one

 

and it bind in dropdown list please any body help