• sqlaz - Thursday, October 19, 2017 8:09 AM

    Isn't this limited by the setting on the options dialog - [maximum number of characters displayed in each column]?  (It allows 8192)

    no, it still returns 255 per row. it shifts the text down to the next line so be careful!
    I did a little article about this a while back.
    http://www.sqlservercentral.com/articles/T-SQL/161941/
    There are some interesting quirks to say the least!