Re: how?

From: <rtproffitt_at_my-deja.com>
Date: Tue, 29 Jun 1999 23:13:26 GMT
Message-ID: <7lbjue$uel$1_at_nnrp1.deja.com>


...Are you sure you want to treat NULL
as zero, which is data?... but that's a
separate issue....

Update table myTable
  set mycolumn := 0
where mycolumn is null;

Robert Proffitt

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 30 1999 - 01:13:26 CEST

Original text of this message