Is there any way around this error. Col1 is a not null field but col2 is not obviously since it is currently empty!
Thanks for the help.
Jodi
Bruno Wolff III wrote:
On Wed, Aug 20, 2003 at 10:16:38 -0400,
Jodi Kanter <[EMAIL PROTECTED]> wrote:how do I copy from one field to another?
update tablename set newcol = oldcol;
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
[EMAIL PROTECTED]