I am unable to assign a string variable more then 256 characters.
 when i display that string it simply truncates and display only first 256 characters.


declare @simply varchar(400)
set @simply='
abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwx yzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuv wxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrst uvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqr stuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnop qrstuv01234567783343'
'
select @simply see

OUTPUT

abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwx yzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuv wxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrst uvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqr stuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnop qrstuv

It is not showing numbers assigned even if the range in varchar is 400
what can be the problem here. is something needs to be configured properly.
Please let me know about this

thanks in advance



regards
rahul pokharna

__________________
regards
rahul pokharna

In Query Analyzer Click on the Tools Menu and then select Options. Goto the Results tab. Look in the Maximum characters per column. I'll bet that it says 256. So change it 8000.


David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Thanks David for the quick reply but sorry for late confirmation

regards
rahul pokharna

rahulpokharna:
No Sweat! The first time that happened to me right after installing SQL 2000 for the first time,
I thought I had discovered a major bug. Instead it turned out to a feature -- but one you can
control.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com