You cannot simply state WHERE column = NULL. You must state WHERE column IS NULL, for example: SELECT * FROM ITEM. WHERE PRICE IS NULL; This will find all rows in the ITEM table where PRICE is null.