Received: from mail.utexas.edu (wb2-a.mail.utexas.edu [128.83.126.136]) by hub.org (8.8.8/8.8.8) with SMTP id RAA13677 for ; Sun, 18 Oct 1998 17:04:04 -0400 (EDT) (envelope-from taral@mail.utexas.edu) Received: (qmail 13892 invoked by uid 0); 18 Oct 1998 21:04:00 -0000 Received: from dial-91-10.ots.utexas.edu (HELO taral) (128.83.249.10) by umbs-smtp-2 with SMTP; 18 Oct 1998 21:04:00 -0000 From: "Taral" To: "ZioBudda" , "Jan Wieck" Cc: Subject: RE: [SQL] NULL DATE Date: Sun, 18 Oct 1998 16:03:59 -0500 Message-ID: <000a01bdfada$d3c41720$3b291f0a@taral> 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 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 Importance: Normal > ok.. > but i have the case > INSERT INTO mytab (a,b,c) VALUES(2,'something','now'); > now i want to set NULL the date item in this tuple. either: INSERT INTO mytab (a,b) VALUES (2,''something'); or if it exists already: UPDATE mytab SET c = NULL; Taral