Is there a limit of 256 on CHAR data?

We are creating some VIEWS that concatenate columns for output to FIXED
LENGTH TEXT FILES - with FIXED LENGTH columns.
This is being done for various transmissions - W2 files to the SS Admin,
1099 files to the IRS, eligibility files to various health organizations.
While testing today, in Query Analyzer, it appeared that saying something
like:
Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
char(10)) as char(280))
The 280 was not liked. In QA we could only see a single column of I'm
thinking around 256 bytes?
Does QA have a max size for column display in the grid?
QA->Menu-> Tools.. Options...Results tab. Maximum Characters per column
box. Adjust as necessary.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Z" <szlamany@.antarescomputing_no_spam.com> wrote in message
news:Om8MaQROEHA.2468@.TK2MSFTNGP11.phx.gbl...
> We are creating some VIEWS that concatenate columns for output to FIXED
> LENGTH TEXT FILES - with FIXED LENGTH columns.
> This is being done for various transmissions - W2 files to the SS Admin,
> 1099 files to the IRS, eligibility files to various health organizations.
> While testing today, in Query Analyzer, it appeared that saying something
> like:
> Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
> char(10)) as char(280))
> The 280 was not liked. In QA we could only see a single column of I'm
> thinking around 256 bytes?
> Does QA have a max size for column display in the grid?
>
|||Steve,
Change the max number in Query analyzer 'tools' menu |options|'results' tab.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Steve Z" <szlamany@.antarescomputing_no_spam.com> wrote in message
news:Om8MaQROEHA.2468@.TK2MSFTNGP11.phx.gbl...
> We are creating some VIEWS that concatenate columns for output to FIXED
> LENGTH TEXT FILES - with FIXED LENGTH columns.
> This is being done for various transmissions - W2 files to the SS Admin,
> 1099 files to the IRS, eligibility files to various health organizations.
> While testing today, in Query Analyzer, it appeared that saying something
> like:
> Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
> char(10)) as char(280))
> The 280 was not liked. In QA we could only see a single column of I'm
> thinking around 256 bytes?
> Does QA have a max size for column display in the grid?
>
|||> The 280 was not liked. In QA we could only see a single column of I'm
> thinking around 256 bytes?
http://www.aspfaq.com/2272
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||Thank you all very much - I was thinking I was crazy...
It worked like a charm.
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:e8QpGWROEHA.2704@.TK2MSFTNGP10.phx.gbl...
> Steve,
> Change the max number in Query analyzer 'tools' menu |options|'results'
tab.[vbcol=seagreen]
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Steve Z" <szlamany@.antarescomputing_no_spam.com> wrote in message
> news:Om8MaQROEHA.2468@.TK2MSFTNGP11.phx.gbl...
organizations.[vbcol=seagreen]
something
>