• The question is:

    it is a BUG?

    ... or it is by design?

    ... or both: it is a BUG by design!

    Try this:

    DECLARE @v-2 char(10)

    SET CONCAT_NULL_YIELDS_NULL ON

    SELECT ISNULL('abcd'+@v,'1234567890')

    RESULT: 1234567890

    This behavior is all right!