Hi Noel,

  You are right, I check the table schema for this table in publisher and subscriber, they were diff

  I've recreate the replication after...

Wow! Thanks alot Enthusiast!!

After I posted my problem yest I keep on this JOIN replacement. Ha!

Option 2 has generate the result I want....

Thanks MohammedU. Understand that this can get fixed will reversing the backward compatibility level. But since we are doing the migration, we decided not to reverse it to keep the...