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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2007-03-26 : 12:34:59
|
| Hi,I am concatenating a message from three different conditions.I want to enter a CR+LF between the two parts. How would I do that? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-26 : 12:35:41
|
+ char(13) + char(10)
KH |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-26 : 12:50:01
|
| Thank you sir, it worked. |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-26 : 12:58:43
|
| The code was the problem. I had to increase the length of the message field accordingly. |
|
|
|
|
|
|
CR+LF