I tried toggling the SET CONCAT_NULL_YIELDS_NULL setting in a query window.

SET CONCAT_NULL_YIELDS_NULL ON I get:

Msg 242, Level 16, State 3, Line 4

The conversion of a...