CRLF in SQL Server
·1 min read·paskov
I needed to insert line breaks into a string in SQL Server. The solution was CHAR(13) + CHAR(10): a carriage return (CR) followed by a line feed (LF), together known as CRLF.
The following example adds CRLF line breaks to the value assigned to OSNOVANIE:
UPDATE NM196
SET OSNOVANIE =
'Вал. превод Реф.@@500' + CHAR(13) + CHAR(10) +
'сума @@547 @@502 @@542' + CHAR(13) + CHAR(10) +
'ориг.сума @@501' + CHAR(13) + CHAR(10) +
'вальор @@505 ' + CHAR(13) + CHAR(10) +
'Наредител: @@522 ' + CHAR(13) + CHAR(10) +
'Бенефициент: @@526 ' + CHAR(13) + CHAR(10) +
'Основание: @@535 @@546'
WHERE CODE = 295 AND NOMID = 196;Related Posts
SQL Server ODBC connection string
2011-09-19