Inserting a line break in the NVARCHAR data in SQL Server

Posted by AbundantCode

For inserting the character break in a data of type NVARCHAR in SQL Server , you can use CHAR(13).

Inserting a line break in the NVARCHAR data in SQL Server

Inserting a line break in the NVARCHAR data in SQL Server

DECLARE @temp_abundantcode TABLE (
    description NVARCHAR(200)
)

DECLARE @value as NVARCHAR(200)
INSERT INTO @temp_abundantcode VALUES ('This is abundantcode''s' + Char(13) + 'site.')

SELECT @value = [description] FROM @temp_abundantcode
PRINT @value
Inserting a line break in the NVARCHAR data in SQL Server
Tags: