Displaying text column content 1

[nsonnek]

I am trying to display the content of a text column and am unable to display anything beyond 256 characters. I've tried several different methods including the following:
1. simple select statement (i.e., select dataxml from nodestate)
2. Bumped up the TEXTSIZE option and reran the select statement above
3. Used the READTEXT method below:

DECLARE @ptrval varbinary(16)
SELECT @ptrval = TEXTPTR(dataxml)
FROM nodestate
READTEXT nodestate.dataxml @ptrval 1 500

Any suggestions would be greatly appreciated.

Thank you.
NSonnek
Sr. Database Engineer

 

[JamesLean]

Are you using Query Analyzer? If so, try going to Tools->Options and in the Results tab increase the value for "Max characters per column".

--James