Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2007-05-23 : 15:27:06
|
I'm running a simple sql query in Analyzer, and one of the fields is varchar and there are records with values in this field exceeding 256 chars. However, the results pane only displays up to 256 chars for all of the records.How do I get it to display all of the char values for the records that exceed 256 chars? Is there a function or syntax that I may use that don't know about? Do I need to convert? if so, I tried cast and convert functions, but they also only display up to 256 chars.Heeeeelp!!!  John |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-23 : 15:36:55
|
| Tools->Options->Results->Maximum characters per columnset to 8000_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
cardgunner
326 Posts |
Posted - 2007-05-23 : 16:25:50
|
Thanks spirit I went there and found how to set my numbers to right align  Card Gunner |
|
|
|
latingntlman
Yak Posting Veteran
96 Posts |
Posted - 2007-05-23 : 17:08:06
|
| That simple, huh.Ok, now I have to see all chars in a Crystal rpt that gets exported to Excel. I'll keep you posted.thx for now,john |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-24 : 11:20:33
|
| "Thanks spirit I went there and found how to set my numbers to right align"You can charge double Spirit!!! |
|
|
|
|
|
|
Query Analyzer only displays 256 chars