Home Forums SQLServerCentral.com Editorials Who Likes NULL? RE: Who Likes NULL?

  • July 6, 2018 at 3:41 am

    #1996503

    edwardwill - Friday, July 6, 2018 2:19 AM

    When designing a table, it is essential to realise that there are real-world circumstances where NULL may be an important and meaningful representation of the data being modelled.

    Thoroughly agree!

    What opinions do people have on, for example, postal address lines? Typically you might have 4 address lines plus city/town, county/state, postal code, country. Most addresses don't use all four lines. If not using NULL, what would you populate the unused address lines with?