I'm in the process of moving one database into a new system and I'm encountering the following issue.
In the original database I have a field Message which is an ntext the line spacings are visible when hovering over the field even though the field looks as as a single line. When importing to the new database and into a different system I need to replace the new line identifier with </p><p> and place an <p> in front of the message and a </p> at the end thus if the message looks like this
Helllo, this is the first line and this is the second.
it should be converted to
<p>Hello,</p><p> this is the first line</p><p>and this is the second</p>
any ideas ?