Example Using IS NULL Predicate - Teradata Vantage

To search for the names of all employees who have not been assigned to a department, enter the following statement:

SELECT Name 
FROM Employee 
WHERE DeptNo IS NULL;

The result of this query is the names of all employees with a null in the DeptNo field.