Received: from emarq.com (lgs21.lgs.com [207.230.254.117] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id TAA03302 for ; Wed, 19 Jan 2000 19:57:33 -0500 (EST) (envelope-from hamid@emarq.com) Received: from hamid.emarq (hamid.emarq [10.10.10.129]) by emarq.com (8.9.3/8.9.3) with SMTP id QAA31627 for ; Wed, 19 Jan 2000 16:56:54 -0800 From: "Hamid Khoshnevis" To: Subject: null and integer field Date: Wed, 19 Jan 2000 16:57:17 -0800 Message-ID: <000601bf62e1$4c1d1040$810a0a0a@emarq> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal The content of an integer field when unassigned appears to be different from pushing a null into that field. Can someone please explain the difference and show me how to push an 'unassigned' into that integer field. I am using: update table foo set integer_field=null where blah blah; Thanks, hamid