sqlaz - Thursday, October 19, 2017 8:09 AM
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!