Selecting with null

SELECT Name FROM Customers WHERE PhoneNumber IS NULL

Selection with nulls take a different syntax. Don’t use =, use IS NULL or IS NOT NULL instead.

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents