Combine more than one column in the same table and display the result as next next li

[praveenakarthi]

Hello All,

I need to combine more than one column and display it next line.

eg:

sno name address company city
1 Bujju India Advent Delhi

I need to get the result as

Personal Info

Bujju,
India,
Advent,
Delhi

I try this Query:

select isnull(Performance.name,'') + CHAR(13) +
isnull(Performance.address,'') + CHAR(13) +
isnull(Performance.company,'') + CHAR(13)+
isnull(Performance.city,'')
from Performance

But I got the result in the same line

Help pl to solve my problem

Thanks

Regards,
Praveen

[Rabbit]

In a microsoft environment, carriage return and line feed is used to indicate a new line. However, this will only display correctly if you use a reporting tool that allows multi-line text boxes. The results in SQL Server itself does not allow multi-line text. So you can put it as many new line characters as you want, you can't see them in SQL Server.