Steve writes in a comment:
"(...) if you look at a string in the debugger trace window, it is truncated..
so if you happen to have a very long sql statment in hte string , or cannot view it, or even edit it"
so if you happen to have a very long sql statment in hte string , or cannot view it, or even edit it"
Indeed, that's correct: as for any array, the debugger will only show 100 elements at a time, for performance reasons, as it may be very expensive to send an unlimited value from the debuggee process to the debugger.
However, you can see the whole String value and edit it.
See more in this article.