Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anujpratap09
Starting Member
5 Posts |
 Posted - 2010-01-30 : 03:22:08
|
| Hi All,I need Carriage return in single column. after some data.So i store data in column is given below.Between 85% & 89.5% in Science & Math’s in Class X board exam. char(13) Or Between 80% & 84.5% in PCB in Class XII board exam. but when i select the column all data showing in a single line and CHAR(13) also showing.please help me.Thanks in advance.Anuj Pratap Singh |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-30 : 04:44:25
|
Yeah, well its just in your "text", so it will display exactly as you have entered it. You need to use it in a string concatenation, if this is SQL then it will be something like:'Between 85% & 89.5% in Science & Math’s inClass X board exam.' + char(13) + CHAR(10) + 'OrBetween 80% & 84.5% in PCB in Class XII board exam.' |
 |
|
|
|
|
|
Carriage return issue in single column