Re: SELECT question

Fred Hurtubise wrote:
>
> I have a table containing 30 columns...
> For each user, some of the columns are either filled or empty.
>
> Question is :
>
> is there a way to select only the column that aren't null
> something like select * from table where column is not null???

Yep, that will work.

P.S. I have a feeling you are asking for more than this. Can you give a sample of the data in the table and a sample of how you want the output to look?

-- 
Tomm Carr  --> Note new e-mail address
tommcatt@computer.org -- http://www.geocities.com/athens/delphi/6769
-- The Macintosh computer is like the open range;
-- In a world without fences, there are no Gates.