Limits on string functions

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.