• Hi Doug,

    thats exactly the purpose of the question.

    If you execute SELECT ISNULL(A,B) FROM #Testyou will get four 1-char strings because of the implicit conversion.

    A

    S

    B

    S

    Since the length of these is 1, the group by returns only one row.

    Hope this helps.

    Best Regards,

    Chris Büttner