Link to home
Start Free TrialLog in
Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Rick
Rick

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of VBdotnet2005

ASKER

ok. Is there a way to get field(73) just header in one shot?