Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

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?
0
VBdotnet2005
Asked:
VBdotnet2005
  • 2
1 Solution
 
RickCommented:
select * from table
where field1 is not null
     and field2 is not null
     and field3 is not null

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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now