SQL Server stitching the values of a column into a string

Name

Seafood Products

Fruit and vegetables

Sea cucumber

Meat and eggs

Steak

Preserved meat

Fresh food

Turn the above column into a:

Fresh food, seafood, fruits and vegetables, sea cucumber, steak, meat and eggs, preserved meats

Sql

Select CAST  as varchar) + ' , '  from  as where GT. Code=1 FOR XML Path ("

SQL Server stitching the values of a column into a string