> Insert into PersonInfo (Client_ID, PersonType, PhoneNumber) select
> Client_ID, 0, PhoneNumber from ClientInfo

Thanks Alexandre--but I need to clarify.

The record in the destination table will already--I just need to move
the data to the existing record.

I'm thinking I need a stored proc. Right?