Hi Brandie,

I guess the final update back will fail on a database with a case sensitive collation. Shouldn't it rather read:

Update idf

Set Location = mt1.Location

from dbo.Import_Data_Filter idf

join dbo.#MyTemp1 mt1

on UPPER(idf.Location) = UPPER(mt1.Location);