sql server new line character

Question

0.00/5 (No votes)

See more: (untagged)

HI,

I am getting records from database(sql server)as comma separated.I am getting contact
titles as

greg w.workcerf,ashir ali,asdddfgjk

This is comma separater has been defined in sql function getCommaListTitle

What i want is to get these record on new lines as

greg w.workcerf,
ashir ali,
asdddfgjk

Any idea about what should i use in sql function instead of ','

Posted 5-Jul-12 22:06pm

khan46

Add a Solution

3 solutions

Add a Solution

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

Sandeep Mewara · Answer 1 · 2012-07-05T22:26:00

Solution 2

If I understood correct, you need to go and change your SQL Function getCommaListTitle.

Here in your SQL function, after your ',' put CHAR(13); or CHAR(10);
This will insert carriage return(code 13) or newline feed(code 10) in the text leading to the text format as you are trying to get.

Posted 5-Jul-12 22:26pm

Sandeep Mewara

Comments

Manas Bhardwaj 6-Jul-12 5:47am

This is correct +5!

Rahul Rajat Singh · Answer 2 · 2012-07-05T22:13:00

Solution 1

Assuming you are doing it in C#.

C#

string s = "greg w.workcerf,ashir ali,asdddfgjk";

string finalString = s.Replace(",", ",\r\n");    //in case it is goiing on windows form
string finalString = s.Replace(",", ",<br />");    //in case it is goiing on web form

Posted 5-Jul-12 22:13pm

Rahul Rajat Singh

Comments

Sandeep Mewara 6-Jul-12 4:27am

Our interpretation differ here. Lets see!

Rahul Rajat Singh 6-Jul-12 4:29am

interpretation are different but both our solutions are correct in their own way(perhaps not in the context of this question). +5 for your solution, liked it.

Manas Bhardwaj 6-Jul-12 5:49am

This is correct. Personally, I would do it at SQL Server (but, that's just me :)). I voted 4.

khan46 · Answer 3 · 2012-07-06T03:51:00

Solution 3

XML

HI All,

Thanks for your quick responses,
Surprisingly,this

<br>', ''

 worked in sql server function .Now i am getting required output

Posted 6-Jul-12 3:51am

khan46

sql server new line character

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

sql server new line character

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us