• Thank-you for the interesting question!

    It is strange that VARCHAR(MAX) would behave differently. Has this ever been reported to Connect?

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins