>>>>>I understand NULLS have a special purpose... but I think I'm starting to abuse it. For example, if we have a text comments area that saves to a varchar field, would it be proper to use NULL if the user left the text area blank, or would it be proper to use a blank string?
>>>>
>>>>I use NULLs for numeric columns. I have business rules that require me to know if a user entered 0.
>>>
>>>There is no question there is a place for nulls, and that's a good example. But I don't believe they should be overused. For example, a typical address provides for two lines of street address, the second typically being used for suite number, apartment number, etc. If it is not specified I consider that an indication that there isn't one, not that its value is unknown. In fact I would be hard pressed to think of a character field that is not required by database rules (street address line 1, for example) that should be nullable.
>>
>>Agreed. In VFP I only used NULLs on numeric columns (for the aforementioned reason). In SQL Server I also use NULLs on Datetime coulmns as Sergy mentioned. How is the TV withdrawl going?
>
>No problem at all. It helps that I don't watch much to begin with, mostly sports and movies on DVD.

TV is the one modern technology I would not miss much. We lived in Germany in the mid 60s and did not see TV for 3 years so I never really developed the watching habit. I read alot, and always have the radio on, but not much TV.