Select Returns 255 of 5000 Chacters in varchar Field

[ctarr]

In SQL 2000, I have a varchar(5000) field that is filled with only 803 characters (including spaces) when I do:
select LEN(Field) from Table1

I get 803 characters as the length.

When I do:
Select Field from Table1

I get only the first 255 characters of the 803.

Is there a limit as to how much data a select will return?

How do I select the entire contents of the field and return it to the Query Analyzer?

Thanks,

Craig

 

[RickCole]

In the query analyser window go to Query then Current Connection Options and onto to the Advanced tab. From here you can amend the number of characters returned as required in your query.

Rick.

 

[ctarr]

Rick in SQL 2000 I don't have the Advanced option on that menu.

I have the setrowcount field. But that's not the issue.

Could you double check your menu and let me know.

Thanks,
Craig

 

[ctarr]

After some digging around in my QA I found the option to modify the max character per column. It is located in Tools | Options | Results.

By changing the default from 256 to 1000 I got the full results back.

Thanks for the help Rick! I

Craig