• sendijunk (1/11/2017)


    Good question. Could use a bit more explanation though. Interesting what happens if you replace ISNULL with COALESCE.

    The return type depends on "precedence" of types. In this case, the longest string of 8 chars.