Find all nulls

al4629740
al4629740 used Ask the Experts™
on
how can I search all nulls.  This statement is not working


select * from attendance where total = Null
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
select * from attendance where total IS Null

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial