Selecting and replacing DATE fields with NULL values

Select date fields with NULL values:

SELECT * FROM Adressbook WHERE mydate IS NULL



Update fields with NULL values to have a default (and optionaly set NULL allowed to false after)


UPDATE    Adressbook
SET       mydate = ''
WHERE     (mydate IS NULL)