Re: Can I select(*) from T only fields that are not null?

deanbrown3d schrieb:
> Can I get a select(*) statement to give back only the fields that have
> data?
>
>
> (I'm running this is SQL plus worksheet, on server 9, client 10)
>
> Thanks,
>
> Dean
>

Yes,
select nullable_field_1,nullable_field_2 from table_containing_nulls
where nullable_field_1 is not null and nullable_field_2 is not null;

Best regards

Maxim Received on Wed Jun 08 2005 - 14:23:40 CDT