How to email as saved on SQL field?

[ombina]

Please help.

When I email me letter format TEXT field, I received unformatted letter form. Meaning my line breaks are joing together as one huge paragraph.

How do I send this through email such as JMAIL so that I receive it nicely formatted?

Thanks so much!

Ricky Thanks,

Ricky

 

[JohnDTampaBay]

I did a little test and text separated by Char(11) on INSERT runs together on SELECT, but text separated by Char(13) on INSERT appears on different lines on SELECT.

To remedy this, UPDATE the text data replacing Char(11) with Char(13). You will do the same type of replacement on future INSERTs.

Good luck! --Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.