>This command would seem quite simple, but I cannot get it to work. The project that I am working on requires some fairly simple data manipulation that I would like to automate using VFP6. My goal is to copy several substrings of data from a field in a table and then append to a new table. I am presently trying to copy the ssubstrings to an array and then append, but the copy command does not work. Any ideas?

I don't think that you may use functions within COPY TO ARRAY. Instead use SELECT ... INto Array ...