New line in Sql Query

Question

How you get new line or line feed in Sql Query ?

score 138 · Accepted Answer · edited Jun 09 '14 at 16:50

138

Pinal Dave explains this well in his blog.

DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)
PRINT ('SELECT FirstLine AS FL ' + @NewLineChar + 'SELECT SecondLine AS SL')

edited Jun 09 '14 at 16:50

Darren Griffith

answered Jul 06 '09 at 06:27

Thanks nice Blog and nice information my problem solve from this – KuldipMCA Jul 06 '09 at 06:40

score 39 · Answer 2 · answered May 04 '12 at 19:38

39

-- Access: 
SELECT CHR(13) & CHR(10) 

-- SQL Server: 
SELECT CHAR(13) + CHAR(10)

answered May 04 '12 at 19:38

Eric Falsken

score 19 · Answer 3 · edited Aug 31 '11 at 00:23

19

You could do Char(13) and Char(10). Cr and Lf.

Char() works in SQL Server, I don't know about other databases.

edited Aug 31 '11 at 00:23

Tim Cooper

answered Jul 06 '09 at 06:28

jvanderh

score 15 · Answer 4 · edited Aug 31 '11 at 00:23

15

use CHAR(10) for New Line in SQL
char(9) for Tab
and Char(13) for Carriage Return

edited Aug 31 '11 at 00:23

Tim Cooper

answered Nov 13 '09 at 05:35

Vinit Prajapati

4 Answers4