This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
How to remove carriage return between objects.
I have a text box and table I want to remove carriage return between them.
Also I have a table with two columns and I want to remove carriage return between these two columns.
Thank You in advance.
Hi ,
Try like this ,
--To replace Carriage return =REPLACE(Fields!Column.Value, CHAR(10), "" ) --To replace Line feed =REPLACE(Fields!Column.Value, CHAR(13), "" ) --To replace Tab =REPLACE(Fields!Column.Value, CHAR(9), "" )
sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.