filed name as a column

How can I display filed name as a column, can any body help...
There is one table name School and it contain 4 records and in the future
might be it will increase but I want to display that records as a column
like this
1........... First School
2........... Second School
3............Third School
4............Fourth School
now I want like this
First School Second School Third School
Fourth School
45 99 0
0
99 22 1
0
Thanks
Thats a crosstab thing which could be handled with y CASE statement:
http://www.paladn.com/dynamic-crosstabs.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Roy" <roy@.hotmail.com> wrote in message
news:uJ4ZN2fgFHA.1148@.TK2MSFTNGP12.phx.gbl...
> How can I display filed name as a column, can any body help...
> There is one table name School and it contain 4 records and in the future
> might be it will increase but I want to display that records as a column
> like this
> 1........... First School
> 2........... Second School
> 3............Third School
> 4............Fourth School
> now I want like this
> First School Second School Third School
> Fourth School
> 45 99 0
> 0
> 99 22 1
> 0
> Thanks
>