locked
How to insert carriage return / line feed in SQL statement RRS feed

  • Question

  • User-2060727494 posted

    I'm using SQL Server 2012.  I have a table with a column named FWNotes.  Here is a sample of some data in this column:

    - Bootloader revision for field upgradability- Adds support for Tetrix and Andymark motors by adjusting PID and Ratio values

    I want to add carriage returns or line feeds so that this text displays like this:

    - Bootloader revision for field upgradability

    - Adds support for Tetrix and Andymark motors

     by adjusting PID and Ratio values

    I notice that when posting here, a line is added between lines automatically.  I just want to go to the next line and not have a blank line like in this post.  I tried adding /r/n after the text where I want it to break but it actually displays /r/n.  How can I do this?

    Friday, May 20, 2016 2:04 PM

Answers

  • User-2060727494 posted

    I added \r\n between lines and it now works.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 20, 2016 6:50 PM