How can I show column value in a row

You can show column values in a table in a single row.try to below code sample..

select * from dbo.Split('vitA, vitB, vitA, protein, vitB,vitA',',')

Hi James,
              Yes it is possible to show column as Row....You can Use PIVOT for it.

 here is demo..................
 
          http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx



hope u solve it.

Thanx,
Pravin.