Something I learnt today, which surprised me… When you do a select statement and it includes a wide text column SQL Query Analyzer truncates that by default to 256 characters.
To get around this go in to SQL Query Analyzer, then go to Tools -> Option, and click on the Results tab. You will see an entry saying :
Maximum characters per column: 256
Change that value, and hey presto it will show you a much wider column.
Thanks, Rob. I can use this info.