Joe Martinez wrote:

>>You should define columns like that as NOT NULL and / or use triggers to
>>set them to 0 when insering / updating.
>>This will save you a lot of trouble...
>
> Yes, good point. Unfortunately, that hasn't happened either.

Just change them now then.
UPDATE X SET Y = 0 WHERE Y IS NULL
Then add the trigger to keep it that way.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services