Im a significant beginner at SQL and also have a table having a column in which i've text, I wish to make use of this text because the body of the email.
However want this body text to possess carriage returns inside it but every time I send an e-mail utilizing it it simply arrives as you line. The written text is:
'Please find your latest statement of account. Would you review any due or pending bills &lifier confirm payment with this Friday.
For those who have questions please contact xx.xx@xx.Com
How do you allow it to be to ensure that carriage returns are stored within the text and used when adding the written text for an email?
You should use the CHAR(13) function to place new lines. For instance:
PRINT 'Hello ' + CHAR(13) + 'Safi'
PRINT 'Hello ' + CHAR(10) + 'Safi'
A much better exmaple:
PRINT 'Please find your latest statement of account. Could you review any due or pending invoices & confirm payment by this Friday.' + CHAR(10) + 'If you have any queries please contact xx.xx@xx.Com' + CHAR(10) + 'Regards'