I'll try that. I hadn't thought of using the LOOKUP() command. I have not ever used it before.
>Jim,
>
>Try the following:
>
>REPLACE ALL Table1.MyColumn WITH LOOKUP(Table2.myMatchedColumn, Table1.KeyId, Table2.KeyId)
>
>
Jim Newsom
IT Director, ICG Inc.