Hi David,

Thanks for your reply. I will give it a look.

Thanks,

TFISHER

>Terry,
>
>Use the STUFF() function.
>
>>I have a memo field in a table. Generally, I can output the contents of the memo field as is. Other times, I need to insert the value of another character field into the middle of the memo field. How can I do this?
>>
>>For example, if the memo field reads: The rain falls mainly on the plain.
>>
>>I want the output to read: The rain in Spain falls mainly on the plain.
>>
>>I need to insert "in Spain" (which is contained in a character field) into the memo field text.