It's not a case of insert into....Select out of. You asked about how the records were saved, so I told you. These records are held in two tables until they are needed.
So, having said that - when I look at the 'master' table, the Chr(13) is there. When I look in the intermediary table (dupwk) the Chr(13) is there. When I looking the cursor (testbook) it is not.
>>The saving of individual records are done with an Insert
>>
>>The SQL that pulls the cursor is :
>>
>>Select Val(b.seq) As qstnum, b.cat, a.script, a.stem, a.respa, a.respb, a.respc, a.respd,;
>> b.itmnum, a.scriptim ;
>>From convatc a, dupwk b;
>> WHERE a.itmnum = b.itmnum;
>> INTO Cursor testbook;
>> ORDER By qstnum
>>
>>Script and Stem are both memo fields
>>
>So, right before INSERT command the memo has chr(13) and right after select it does not?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place