How to add New line character or line break in sql statement

Last Reply on Apr 23, 2012 09:28 AM By Mudassar

Posted on Apr 23, 2012 07:20 AM

hello 

I want to add new line charachter in the sql statement 

Sql 

 

  DECLARE @text NVARCHAR(100)

 

SET @text = 'This is line 1.'  + (line break charachter) +  'This is line 2.'

SELECT @text

 

I want output like this 

 

This is line 1.

This is line 2.

 

can you please tell me how to use break the line in sql 

 

 

 

 

    

You are viewing reply posted by: Mudassar on Apr 23, 2012 09:28 AM.