Results of string functions are limited to 16K.
If set string_rtruncation is on, a user receives an error if an insert or update truncates a character string. However, SQL Server does not report an error if a displayed string is truncated. For example:
select replicate("a", 900) + replicate("B", 900)
Displays the first 16K of data, but the subsequent data is not displayed.