Carriage Returns and Line Breaks

Hot Topic

Is it possible not to keep together textfields?
OLAP Theory
Page headers and using more than one table in a report
NULL values in Cube for measures
Default Install of SQLExpress Does NOT Work Well
Package running other packages
What is a Transfer Task?
creating an adjacency list from a parent - child table
problem to generate a nextNumber or to use Autoincrement
Add database in VWD - can't find SQLExpress

SQL Server

Is there a way to create a dynamic Insert on Stored Proc?
using ssis to generate load
What do I need to make my own custom SSIS components?
Adding data to columns
SSMS Express: Create TABLE & INSERT data into table - Error Msgs 102 & 156
how to pass a VARIANT data to SQL Server ?
SQL Server and SQL Mobile
Setting up Sql Mobile subscription
How to copy local sql express DB to remote full sql server 2005
xp_cmdshell: a call to 'CreateProcess' failed with error code: '5' (under SQL2005 RTM)

Carriage Returns and Line Breaks

I have an address field that is coming back as a single field with carriage returns and line breaks and I would like to have it properly wrap in a single box, but the wrapping is all off. How can I get this to properly break Thanks

Answer this question

Carriage Returns and Line Breaks

  • ArunDeivanayagam

    try select field1 + char(13) + char(10) + field2



  • kob_kob

    Nope. That is not the issue. It is cangrow = true.

    What I want is to take a field that comes out as:

    John Smith CR LB 123 Main Street CR LB Anytown, MA 01888 CR LB USA

    as

    John Smith

    123 Main Street

    Anytown, MA 01888

    USA

    What I am getting is:

    John Smith 123

    Main Street Anytown,

    MA 01888 USA

    So I am looking how to read the CR and LBs and maybe replace them with BR tags, not sure.

  • jn4u

    Make sure you have text box property "cangrow" to true.

  • Astronutty

    Also... what is being returned to indicate the line break are char(13)s. I am recreating a report that I had lost and was able to resolve this at one time, but forget how I got around it.
  • Carriage Returns and Line Breaks
Answer this question