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>
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