You could do a select into a temporary cursor then do a replace to the new table.
Jason Nance
jbnance@gw.orl.ilstu.edu
>I want to perform a APPEND FROM and here is my code:
>
>use new_table
>append from old_table
>
>The problem is there is a fld in my new_table called new_value
>and a fld in my old_table called old_value. I want the values in old_value to be inserted in the fld called new_value. What would the code look like to do something like this? thanks