>How do you set a numeric field to NULL?
Same way as any other type. Just make sure you ALLOW NULLs first. You can even do it on the fly with:
ALTER TABLE mytable ALTER COLUMN somefield NULL
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.