NULL Record

[Olivia Towery]

How do I write select statement to choose records with a specific field that
is NULL? Example - I want to select all records who do not have any email
listed.

Thanks,

--
Olivia Towery
Tower Internet Management
Phone - 909.652.8064
Fax - 909.652.8068
Cellular - 619.454.5005

 

[Andrew Durstewitz]

Select * from User_Accounts where Email = ''

* * * Sent via DevBuilder http://www.devbuilder.org * * *
Developer Resources for High End Developers.

 

[Aaron Bertrand - MVP]

If it is only NULL:
SELECT columns FROM table WHERE email IS NULL

If it is NULL or empty string:

SQL Server
SELECT columns FROM table WHERE COALESCE(RTRIM(email), '') = ''

Access, maybe this?
SELECT columns FROM table WHERE NULLIF(email, '') = ''


*ALWAYS* useful to post the database you're using and the version...