ISNULL vs COALESCE

I got this tip from reading my friend, Louis Davidson's blog.

Be sure to check out http://sqlservercode.blogspot.com/2006/06/coalesce-and-isnull-differences.html to see some good examples of why ISNULL and COALESCE are not the same nor are they interchangeable.

Hope this helps!

-Kev

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish