NULL Operator

If you need to identify records that have a NULL value, you must use the IS NULL comparison operator

SELECT order#, shipdate
FROM orders
WHERE shipdate IS NULL;

SELECT order#, shipdate
FROM orders
WHERE shipdate IS NOT NULL;

Back To Top- Home - Category