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.

All Forums  General SQL Server Forums  New to SQL Server Programming  how to display strings more than 8000 characters

Author  Topic  subhi Starting Member 9 Posts Posted - 2010-03-12 : 14:52:27 I have to display a fied length record which may run up to 32,000 bytes in each line. these records are from each column from a table which i concatenate to one fixed length record but how can i now export to a flat file when i save using print only 8000 characters as print command has retriction of printing 8000 characters. if i use select also i have the same problem . what would be the other ways. thanks