select statement - withou null value

I have a table which contain 73 fields. I don't want to get any fileds that has null value. How could I query it?

select *from table1 where field1 in not null, etc. One at a time?  Is there a better way?
Who is Participating?
RickConnect With a Mentor Commented:
select * from table
where field1 is not null
     and field2 is not null
     and field3 is not null

No better way.
VBdotnet2005Author Commented:
ok. Is there a way to get field(73) just header in one shot?
VBdotnet2005Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.