Version: 6.7.x, 6.8.x and 2003

This tech tip contains a simple strategy to use for those implementations where you are storing numeric values and you want a field to be empty if no data has been entered.

4D's numeric fields use zero as a null value. A strategy you might use for your implementation would be to store the data in an alpha field, since alpha fields are null if no data is entered. If you use this strategy you will have to convert the data to a numeric value for those instances where you want to do calculations.