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 






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