• SET CONCAT_NULL_YIELDS_NULL ON

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

    if i add any numeric value then it gives->1234567890 why?