Check for blanks in a row

[wrightyrx7]

Hi all,

I have a query with 11 fields. Is there a way i can check if any of the fields in a row is blank?

I was wondering if a count would work in some way?

Thanks in advance
Chris

 

[Ranman256]

run a query.
this query has IS NULL in every field criteria.

 

[CJ_London]

something like

 select *
 from mytable
 where fld1 is null or fld2 is null or fl3 is null....

 

[wrightyrx7]

Thanks Ranman, but this just pulled out records where all fields were null.

something like

 select *
 from mytable
 where fld1 is null or fld2 is null or fl3 is null....

This is what i wanted. Thanks CJ.