Add the following #DEFINE --
#DEFINE CRLF CHR(13)+CHR(10)
Then insert CRLF -- this should provide for a new paragraph (to insert a blank line, insert two CRLF's sequentially).
>Ok, good stuff so far from everyone. Have one problem left. Using CHR(13) or CHR(10) has no affect on the format of the text, just inserts some control characters. I need to break my text into paragraphs, but it doesn't seem to want to.
>
>>Use the STUFF command--
>>
>>
>
>>lcTxtToInsert = " Some text to insert "
>>lnNdx = 10 && Insertion point
>>REPLACE mytable.mymemo WITH STUFF(mytable.mymemo,lnNdx,0,lcTextToInsert)
>>
>
>>
>>You have to determine the insertion point (lnNdx). The third parameter with a value of zero (0) on STUFF inserts the text; if a value (>0) is set then the text is replaced from start point.