>
>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
Well, wind does change. If yesterday it was 270 degrees at 15 knotts and then updated it today to null at 0 knotts would that be appropriate? This is interesting because I hadn't thought about it before and agreed with; then Cetin posted. I guess there is a time for everything. If degrees was an integer then I would have to set it to null as 0 might not be appropriate although it is not a degree. hmmm
Tim
Timothy Bryan