--Step 1
Declare @STR VarChar(max);
Set @STR=Replicate(cast('*'as varchar(MAX)) ,10000)
Print Len(@Str);
--Step 2
Declare @STR VarChar(max);
Set @STR=Replicate('*' ,10000)
Print Len(@Str);
----
i m hardly got the difference between step 1 and step 2 ..please explain both ????
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)