UPDATE table1 SET column_a IS NULL WHERE column_b = 'XXX';
ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;