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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-26 : 06:55:56
|
| Joel writes "Am using a stored procedure to check for expiring contracts and then email the interested employees. Would like to be able to force line breaks in the body of the email but SQL server doesn't seem to like vbcrlf, chr(10), etc. Is there any way to add line breaks to the body of CDONTS when called from a SQL stored procedure?I am running Windows 2000 server and SQL Server 2000." |
|
|
sorengi
Starting Member
48 Posts |
Posted - 2004-05-26 : 15:18:55
|
| try using "CHAR(13)" (carriage return), and see if it works...Michael D. |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-05-26 : 15:39:12
|
| general form within procsdeclare @CRLF char(2)declare @msgstr varchar(800) SET @CRLF = char(13) + char(10) SET @msgstr = 'This is my story' + @CRLF+ ' by Sitka'It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
|
|
|
|
Line Breaks in the CDONTS Body from Stored Procedure