Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003

    Unanswered: How do I insert CR/LF - CHAR(13) does not work

    I need to send some long emails, problem is when I send a long body text CDO breaks up the message with spaces in the middle of words. I read on this forum the solution would be to insert CR/LF into the message so that CDO would not have to break it up at every 1k of text. I have tried using CHAR(13) as BOL suggests, but this is not doing as intended, it inserts a space and not the CR/LF I need.

    Any suggestions how to insert CR/LF or why my installation is not responding to CHAR(13) is there some other escape code I could use?

  2. #2
    Join Date
    Feb 2004
    Char(10) ?

  3. #3
    Join Date
    Jan 2004
    In a large office with bad lighting
    An ASCII cr/lf is hexidecimal 0D0A. You could declare a char(2) variable and set it to 0x0D0A, then concatinate it to the string at your desired break points.

    declare @crlf char(2)
    select @crlf = 0x0D0A




  4. #4
    Join Date
    Nov 2003
    Hmmm, seems to work, my bad - I guess the results in QA are not accurate, but in the email the CR/LF exists.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts