can we save a null instead of zero in numeric feild in SQL ...i mean is there any predefined function in SQL which save the null if the value is zero and save regularly if that value is not zero..
insert into x value y
i need to insert null if y is zero and regular value where y is not zero..
where y is declared as long in c++.
y=0 then x = null
if y !=0 then x=y;
If their is no predefined function can i have a snnipet code which does that