Creating a fixed width file 1

[commatom]

I am trying to create a fixed width file for another system to receive.

I have it all written in SQL but when I run it the record truncates at 255 characters.

Obviously I need to convert the output to some other type of datatype (text?)

Can someone point me in the right direction?

Thanks!

 

[gmmastros]

There is a setting in Query Analyzer....

Click Tools -> Options... -> Results -> Maximum characters per column


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[commatom]

DUDE! You are awesome!

I have been working on this all day!!!