How to store "new line" in SQL Server 2008 R2

Question

I want to use new line in my select query

For example:

SELECT
    FULLNAME + ADDRESS AS X1
FROM 
    TBL_USERS

and the result should be something like this:

ABBAS KOLAHDOOZAN
ISFAHAN,BOZORGMEHR ST

as a single column.

I use CHAR(10), CHAR(13) but that dont work.

Does anyone have a working solution?

You need to expand on 'dont work' – Nick.Mc Dec 22 '14 at 05:22 — Nick.Mc, Dec 22 '14 at 05:22

score 5 · Answer 1 · edited May 23 '17 at 10:26

5

The Sql

SELECT
 FULLNAME + CHAR(13) + CHAR(10) + ADDRESS AS X1
FROM
TBL_USERS;

Will insert a Windows CRLF between the columns. What you might be seeing is SSMS's Output to Grid results, which will eat whitespace. Switch to Text results mode if you want to see the actual result.

edited May 23 '17 at 10:26

Community

1
1

answered Dec 22 '14 at 04:51

StuartLC

104,537
17
209
285

Dinesh Reddy Alla · Answer 2 · 2014-12-24T06:30:22.827

0

DECLARE @name VARCHAR(MAX)= 'ABBAS KOLAHDOOZAN'
DECLARE @town VARCHAR(MAX)= 'ISFAHAN,BOZORGMEHR ST'
DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)

PRINT( @name + @NewLineChar + @town)

edited Dec 24 '14 at 06:30

answered Dec 22 '14 at 10:44

Dinesh Reddy Alla

1,677
9
23
47

i want to select no print – user1557443 Dec 24 '14 at 04:55
SSMS will display it in a single line if you have the output showing in a grid. If you change the output to text it will display multiple lines. (Ctrl+T = Results to Text Ctrl+D = Results to Grid) – Dinesh Reddy Alla Dec 24 '14 at 05:55

How to store "new line" in SQL Server 2008 R2

2 Answers2