You are a genius, George.  That seems to work very well. Thanks for your help.

I believe your update query works but I didn't explain well enough that the I am trying to update the UDF table and not the UserImport table.  To be specific...

I understand what you are saying and I agree. I'm my situation, I am updating product information on a remote sql server with data from a local sql server....

There is nothing else going on that specifically requires me to do it that way other than that's the only way I know to get the information back out. ...