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.