• SET CONCAT_NULL_YIELDS_NULL ON

    SELECT ISNULL('abcd'+NULL,'1234567890')

    I got answer '1234'

    Can you please explain???

    Thanks and Regards

    vijayakumar.P

    😛