Home Forums SQL Server 2012 SQL Server 2012 - T-SQL and x is NULL <> and x = 'NULL' RE: and x is NULL <> and x = 'NULL'

  • August 22, 2013 at 2:03 pm

    #1644130

    Koen Verbeeck (8/22/2013)

    You'd be suprised what you can find these days 🙂

    In the same file something was doing MATH on a phone number column during import.

    So 212-555-5555

    or 212-555-5555 / 212-555-5556

    Were being treated as expressions. They were saved as General format in Excel. When I changed the format to Text, they went in fine.