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 |
|
SLM09
Starting Member
31 Posts |
 Posted - 2009-11-20 : 10:33:28
|
| Hey all- easy question hopefully.Does anyone know how to get a next/new line within a cell in SQL? I found code like this online that utilizes char(13):Select 'a - in a line' + char(13) + 'b - in the next line'... but it isn't working for me.Basically I want the line above to display as-A - in a lineb - in the next lineWithin one cell.Thanks in advance! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-20 : 10:48:08
|
The result with line break is not visible in a grid-result.Change results to text and you will see.Perhaps you need char(10) instead of char(13).
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
New Line within a Cell