>Really? What would the value of say ShippedOn until the order is shipped? Or in a measurement of sea temperatures from -70m to surface per meter and your probe somehow couldn't record at some meters? Or in wind speed and direction, if speed is 0 what may be the direction?
>Null is a meaningfull value as Unknown or N/A, it doesn't always mean user not entered.Yes, of course ... I agree with you 100%. Unknown or N/A is totally appropriate for NULL. I thought I was implying that, but I guess not. But also, in that situation, the user wouldn't have put something into that field to begin with, right? <g>
~~Bonnie