• --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;-)