Actually I was happy when I found how to append characters in text data type, but It doesn’t solve the problem. I have told by Gary that Text, nText, and Image data type will be removed from SQLServer data type in the future. The replacements are max specifier in varchar, nvarchar, and varbinary data type. For example, varchar(max) to replace text, nvarchar(max) to replace ntext and varbinary(max) to replace image. I also have checked it, varchar(max) has the same maximum characters as text data type. They only could save less than 2^31 character. If you want to check it too, you could check it by below codes.
(2^31 is 2,147,483,648 )
Declare @Parm1 varchar(max)
select @Parm1 = replicate(‘a’, 2147483647)
select @Parm1
If you specify the number of replicated strings the same as 2^31, you’ll get the following error.
Arithmetic overflow error converting expression to data type int.
So, if you ask me what SQLServer data type which has undefined number of characters, I will answer you they don’t have. 
