Update NULL values MDB table

Question

How do you update NULL values within mdb geodatabase table using ArcGIS Field Calculator (service pack 4) without changing other values to NULL? I've tried the suggestions on this previous question:

How do you test for a NULL string field in the Field Calculator with Python?

When I run the script it changes everything to NULL.

def RemoveNULL(x):
    if x is None:
        return '0'

---

RemoveNULL(str(!myxField!))

e.g.

before running script

1
23
NULL
5

after running script

NULL
NULL
NULL
NULL

Can you not use python script on mdb table?

Thank You!

Answer 1

You logic is wrong. The way it reads now, if not null, then put 0. That explains why null is now set to zero. Because if not null, so it it is null then it equals 0.

Can you post more of the code?

Answer 2

Ok, thanks to Jamie here is the working solution:

def RemoveNULL(x):
    if x is None:
        return ''
    elif x == '':
        return '0'
    else: return x

---

RemoveNULL(str(!myxField!))