Only returning enteries with Data

[lhg1]

Hi

I have a SQL that returns quite a lot of colums.
I using Toad and whot I want is to only return the colums that contains data.
Its a select * and the colums that have data are not always the same.

My quistion.
Is there any way to only return colums that contain data?

Regards
LHG

 

[Dagon]

It's not clear from your question what you mean. Can you give an example.

 

[carp]

I don't think so. Your query does the vertical striping based on your SELECT list. Likewise, if you try to eliminate columns with no data by using a WHERE clause like
WHERE column2 IS NOT NULL
your data set will be striped horizontally, thus leaving out rows of interest.