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


I want to add new line charachter in the sql statement 





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 






I agree, here is the link: