MSSSQL Server 2000 Query Analyzer select statement

How to increase the column return size

[emsaw]

Howdy all,

I'm doing a simple select statement in Query Analyzer on a large column (varchar(6000)).. I want to see the contents of that column, so I am doing a:
SELECT columnName FROM Table

It's truncating the return data, so I can't see the entire contents of the column. How do I tell it to return the entire contents of that field?

I ran across this problem before, and I can't remember how to remedy this. Anyone else?

Thanks,

mark

[emsaw]

Duh.
I figured it out.
It's as simple as doing a substring on the column name

ala

SELECT SUBSTRING(columnName, 0, 6000) FROM TableName

Mark

[aspdaddy]

Or change the setting in
Tools -> Options -> Results -> Max Characters