sql如何将0替换为空

SELECT *,NULLIF(F_TDID,NULL) as anyVariableName from SWGL_FCS_FCXX;，这样写对吗？

select if(F_TDID=0,null,F_TDID) from SWGL_FCS_FCXX