data not showing in new line

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I am trying to like this:

SQL

SELECT US_Hno + ', ' + US_Street
+ CHAR(13) + CHAR(10) --new line feed char
+ US_Area
+ CHAR(13) + CHAR(10)
+ US_City
+ CHAR(13) + CHAR(10)
+US_Country
+ CHAR(13) + CHAR(10)
+US_Mobile

AS Address FROM TBL_User where US_ID=34

But it is showing result like this-
#21, M.Palya Malleshwaram Bangalore India 8050552756

But I wnat to display in this format:

#21, M.Palya
Malleshwaram
Bangalore
India

Please help me....
8050552756

Posted 2-Aug-12 1:04am

Raju2049

Add a Solution

Comments

AmitGajjar 2-Aug-12 10:07am

it's not always you do work in stored procedure this could be simple done from UI side.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2012-08-02T01:09:00

Solution 1

Hi Raju,
Use this:

SQL

DECLARE @Res VARCHAR(50)
SET @Res=(SELECT US_Hno + ', ' + US_Street
+ CHAR(13) + CHAR(10) 
+ US_Area
+ CHAR(13) + CHAR(10)
+ US_City
+ CHAR(13) + CHAR(10)
+US_Country
+ CHAR(13) + CHAR(10)
+US_Mobile 
AS Address FROM TBL_User where US_ID=34)
PRINT @Res

Select statement will select the data in table, hence, it won't display in new line.

Try this:

SQL

SELECT US_Hno + ', ' + US_Street
+ CHAR(13) + '</br>' -- This will break the line in front-end
+ US_Area
+ CHAR(13) + CHAR(10)
+ US_City
+ CHAR(13) + CHAR(10)
+US_Country
+ CHAR(13) + CHAR(10)
+US_Mobile 
AS Address FROM TBL_User where US_ID=34

--Amit

Posted 2-Aug-12 1:09am

_Amy

Updated 2-Aug-12 1:43am

v3

Comments

Raju2049 2-Aug-12 7:32am

Hi, amit I am trying to do this by stored procedure. after that take value in dataset. And I think it is not possible to get data by using print statement.
Why the way i am using select and return option again it comes in new line

_Amy 2-Aug-12 7:39am

Then instead of CHAR(10) use '</br>'. Try my updated answer.

__TR__ 2-Aug-12 7:51am

My 5.

_Amy 2-Aug-12 7:56am

Thanks Tejas. :)

__TR__ 2-Aug-12 12:46pm

You are welcome.

devsuja · Answer 2 · 2012-08-02T23:44:00

Solution 3

hi,

use this dont use html tag inside the procedure

SELECT US_Hno + ', ' + US_Street
+ CHAR(13) + '/n'
+ US_Area
+ CHAR(13) + '/n'
+ US_City
+ CHAR(13) + '/n'
+US_Country
+ CHAR(13) + '/n'
+US_Mobile
AS Address FROM TBL_User where US_ID=34

Posted 2-Aug-12 23:44pm

devsuja

v2

Philip Stuyck · Answer 3 · 2012-08-02T23:50:00

Solution 4

Just set your result to text format instead of table format in sql server management studio and the new line will work.

Posted 2-Aug-12 23:50pm

Philip Stuyck