>I have a table which contains records with a character field for text and a character field for a memo_key which references that text to some other key in other tables. I want to consolidate the 65 character text fields common to a particular memo into a single memo field. The natural syntax would be append the character field to the memo field. What is the VFP syntax to do that?
>
>TIA
To append to a memo field just type:
REPLACE
WITH +
If this is what you mean, them remember to PACK the table often, because of the fast growing memo file.
Benn Kjaer
MS Certified Professional - Visual Foxpro
"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"