|
|
Posted by Hugo Kornelis on 10/02/62 11:48
On 23 May 2006 21:09:32 -0700, Edgar wrote:
>Hello,
>
>Using SQL SERVER 2000
>
>I have 4 columns with varchar(80) each that I want to concatenate.
>When I look at the result, it only gives me 256 characters. What am I
>missing on my code?
>
>Select Cust_Number, Info = convert(varchar(1000),rtrim(line1) +
>char(13)+rtrim(Line2) + char(13)+ rtrim(line3) + char(13)+
>rtrim(line4))
>>From tableOne
>Go
>
>Thank you for your input.
>
>Edgar
Hi Edgar,
Query Analyzer is displaying only part of the results.
Click "Tools" / "Options" and activate the "Results" tab. Increase the
"Maximum characters per column" to at least 320. Now rerun the query.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|