NULLing Columns with UPDATE
From InterBase
Go Up to Updating Data (Embedded SQL Guide)
To set a column’s value to NULL during update, specify a NULL value for the column in the SET clause. For example, the following UPDATE sets the budget of all departments without managers to NULL:
EXEC SQL UPDATE DEPARTMENT SET BUDGET = NULL WHERE MNGR_NO = NULL;