|
|
Posted by Edgar on 10/02/72 11:48
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
Navigation:
[Reply to this message]
|