Re: UPDATING TO NULL

Kirt You were almost there: update Table set column_name = null where column_name2 = VALUE will do it. HTH Sujit kirt <kirtt@mediaone.net> on 04/29/99 08:55:24 PM Please respond to kirt <kirtt@mediaone.net> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: UPDATING TO NULL How do I update a field with NULL (blank it out) I have tried something like update Table set column_name to null where column_name2 = VALUE the field is an integer that is a foreign key to another table's id column thanks kirt