Hello,

Thanks for helping me with this... I really appreciate it.

I have a table called tblPatientDemographics with a number of columns.
I would like to count the number of NULL values per record within my
table.

tblPatientDemographics
PatientID Age Weight Height Race
1234567 20 155 <NULL> Caucasian
8912345 21 <NULL> <NULL> <NULL>

In the first example above I want to display '1'
In the second example above I want to display '3'

Any help would be very much appreciated.

Thanks !

Chad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!