querying varchar column having length more than 255

[cooljockey]

i have one table in sql server 2000 with field varchar(1000). whenever i fire select query it returns me only 255 characters of that field. why and how to select all. (i fire query in query analyser as well as thru JDBC same result)

 

[RickCole]

From your query analyser window go to Query and the Current Connection Options. On the advanced tab change the Maximum Characters per column to a 1000.

Rick.