I have 3 columns as varchar(255). All the three columns are completly filled. When I write the following concatinated select query, it gives only 255 char output.

select rtrim(col1)+rtrim(col2)+rtrim(col3) from tmp

Do you guys know why is that?. Is this sybase (SQL) restriction that length of each output column is max 255?

Thanks

You try to concatenate three strings of 255 chars length together.
The max stringlength is 255, so the new string will be truncated.

Either try: select rtrim(col1), rtrim(col2), rtrim(col3) from tmp
if possible or upgrade your ASE Version.

Thanks for your reply.

I have ASE 12.0.0.5 Ver. Which version supports more than 255 chars?

Thx.

What version of open client are you running. Is it 12.0.0.5 as well?

I haven't used 12.0.0.5, but 12.5 allows "large" columns too.

You may also want to check whatever you are using to retrieve the data. In others words if you are using a tool such as WinSQL or SQL Advantage they may limit the information returned. If it is within some code check the length of the variable that retrieve's the data etc.

Just a thought.