Sql Server Programming :: case select by column


	case select by column is it possible to do the following ? table has ID,number,column1,column2,column3,column4 i need to select a column by the value in the number column eg results would be 1,1,column1 2,3,column3 3,2,column2 4,1,column1 eg if number =1 then select column1, number=2 select column2 etc possible ? thanks in advance mark hi see my blog on Rotate a table in SQL Server http://oneplace4sql.blogspot.com/ VT Knowledge is power, share it.... http://oneplace4sql.blogspot.com/ "luna" <lun@themoon.com> wrote in message news:KO-dnTcFWPBRRPrbnZ2dnUVZ8s6gnZ2d@giganews.com... - Hide quoted text - > is it possible to do the following ? > table has ID,number,column1,column2,column3,column4 > i need to select a column by the value in the number column > eg results would be > 1,1,column1 > 2,3,column3 > 3,2,column2 > 4,1,column1 > eg if number =1 then select column1, number=2 select column2 etc > possible ? > thanks in advance > mark "vt" <vinu.t.1@gmail.com> wrote in message news:O$5k77OqHHA.1288@TK2MSFTNGP06.phx.gbl... > hi > see my blog on Rotate a table in SQL Server > http://oneplace4sql.blogspot.com/ > VT > Knowledge is power, share it.... > http://oneplace4sql.blogspot.com/ ahh union join, i wasnt thinking properly this morning cheers for the hints mark