Re: SELECT question

Fred Hurtubise wrote:

>
> 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???

What you describe sounds trivial; you have already stated it:

select col1, col2, . . . from <table_name> where colx is not null (and coly is not null and colz is not null);

Regards
Rollin Weeks Received on Wed Sep 03 1997 - 00:00:00 CDT