IS NOT NULL
The IS NOT NULL operator matches a non-null value.
Syntax
WHERE x IS NOT NULL
Example
SELECT Employees.FirstName, Employees.LastName, Employees.WorkPhone
FROM /services/databases/ds_service/Employees Employees
WHERE BillingRate IS NOT NULL