Convert Zero Value to Null?

[tombi5150]

Anyone know of an SQL function which converts a Zero value to a null?

Thanks

 

[rtmpxr]

update <table name> set <field>=null where <field>=0