Recent content by piupiu

Thanks for your reply. No, I just want to list down all the products in the column separated by comma and the products may be repeated. I think there should be a loop to scan all the rows in the column and find commas. The group by is used after all the products is collected, then I will do a...

Hi All, I have a database table like: Supplier Product Company A A,B,C,D Company B B,D,G Company C G,A Company D A,F,B,C ...... .........(unlimited rows) Now I want to list down all the values...

Hi, I need you help...I am doing my Final Year Project now... My database has a table call "Data", inside the table there are 2 fields-"Supplier" and "Product". The string value in product column is comma separated (Shown Below). Product 1 HOSE, FITTINGS 2 GENERAL HARDWARE 3 4 IC...