would that apply to a cursor that I created?

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