ID SO_DATE DESC REMARKS START_D COMPLED AMOUN 5022984 10-Apr-08 10-Apr-08 5023040 24-Apr-08 24-Apr-08 5023073 30-Apr-08 30-Apr-08 5023096 4-May-08 4-May-08 5023106 4-May-08 4-May-08 5023108 4-May-08 4-May-08 5023127 5-May-08 5-May-08 5023150 11-May-08 11-May-08 5023158 13-May-08 13-May-08 Columns With Data Columns Without Data ID DESC SO_DATE REMARKS START_D COMPLED AMOUN In this example there are 3 columns with data and 4 without data. What I want to do actually is to select columns with data and display. So in the result i am expecting these three columns(id,so_date,compled).