Testing for a non null value in Microsoft Access

The test on a NON NULL value in Microsoft Access in incredibly ANSI compliant.

update table set colum = value where colum IS NOT NULL