How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

by

char(13) is CR. For DOS-/Windows-style CRLF linebreaks, you want char(13)+char(10), like:

'This is line 1.' + CHAR(13)+CHAR(10) + 'This is line 2.'

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. SQL Server Exec issue [closed]
  3. Count(*) vs Count(1) – SQL Server
  4. How do I escape a single quote in SQL Server?
  5. NOT IN vs NOT EXISTS
  6. Only inserting a row if it’s not already there
  7. Unpivot with column name
  8. Selecting data from two different servers in SQL Server
  9. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  10. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  11. SQL Call Stored Procedure for each Row without using a cursor
  12. How to select the last record of a table in SQL?
  13. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  14. SQL string comparison, greater than and less than operators
  15. Splitting the string in sql server
  16. How do I group on continuous ranges
  17. Need to list all triggers in SQL Server database with table name and table’s schema
  18. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  19. Get previous and next row from rows selected with (WHERE) conditions
  20. Does Sql JOIN order affect performance?
  21. Best equivalent for IsInteger in SQL Server
  22. How to list files inside a folder with SQL Server
  23. Using tuples in SQL “IN” clause
  24. Can SQL Server Express LocalDB be connected to remotely?
  25. Backup a single table with its data from a database in sql server 2008
  26. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  27. COALESCE Function in TSQL
  28. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  29. SQL Sort Order with Null values last
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment