I need a Query

Hi ,

          If I have table A , It Contain 50 Columns and 1000 rows.In between 50 columns,
some null columns also there.i want only show the output in not null columns.

If you have above solution of query pl send to me.....

Sample...table

  SNO S1 S2 S3 S4 ----- --------- --------- --------- ---------

  100        50                  40
  101        20                  30
  102        30                  40
  103        40                  50
  104        20                  30
  105                            34
  106        65                 565
  107        45                  34
  108        34                  56

I want the output

  SNO S1 S3
----- --------- --------- ---- ---------

  100        50                  40
  101        20                  30
  102        30                  40
  103        40                  50
  104        20                  30
  105                            34
  106        65                 565
  107        45                  34
  108        34                  56

Bye...K.Murugesan Received on Tue Dec 06 2005 - 01:02:20 CST