Hi

Thanks for your query with Merge join New thing learned today on this.i have heared on this but not worked with data but now it also has been done so again spl thanks.

update #myTable set column2='TEST' where column1=2

If we use CHECKSUM then it does not check the above thing i have changed column2 as UPPER Case.It will be work in BINARY_CHECKSUM

If i update column2='TESTS' then it works

update #myTable set column2='TESTS' where column1=2

This is fine.But there is change in the string to UPPER Case which also need to be tracked must be updated in #myTable_hist Table how can we do this

Thanks

Parthi