• Instead of using ISNULL I would recommend using COALESCE instead. This is an ANSI standard. You might need to verify that the values are actually NULL and not just empty or ''. Try using the COALESCE instead and I would recommend using this going forward.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com