Thank you for your feedback h.tobisch. That is interesting, good to know that the platform enforces that behavior. Adding the isnull() check would certainly cover other failures, and may...

I have enjoyed many great articles published to sqlservercentral.com. I am very happy to "pay it forward"!

Thank you all for the compliments!

-Chad Feghali

RichB (6/22/2015)

---

May I suggest showing an extra couple of screenshots of the query plans showing where to see the implicit conversion? It might add a little to the learning...

MarbryHardin (6/22/2015)

---

Good to know.

I'd point out that if someone's application is calling the same query repeatedly in a tight loop you might have a design issue though. You likely...

I have enjoyed many great articles published to sqlservercentral.com. I am very happy to "pay it forward".

---

Thank you all for the compliments!

-Chad