Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by James Travis Understanding the difference between IS NULL and = NULL RE: Understanding the difference between IS NULL and = NULL

  • June 20, 2003 at 9:11 pm

    #462505

    Too lazy to remember the rules about nulls and ANSI NULLS and empty strings, so I avoid tripping over them.

    Typically, I use comparisons like this:

    isnull(@variable,'') = ''

    isnull(@variable,0) = 0

    coalesce(@variable,@anothervariable,'') = ''