Thanks for your help.

Indeed, it was null causing the issue. I checked with hashbytes('md5', 'hello'+'') and hashbytes('md5', 'hello'+null)

column names wrapped within isnull fixed the issue.

Thanks Alex. Appreciate your response.

Question - to initiate the merge, I'll need the ON statement. The ON statement itself will need to have the key I'm merging on. Sorry, if...

forgot to ask...seeking help from others on how to implement the logic please.