I am not sure why the Update query is not working in the attached db.
There are special characters and I am stipping them out.
I have Replace to "replace" any "-" and any "0" but it doesnt seem to want to update.
I only have the suspect record in the db and I have copied this record below between the 2 tables:
0045-000-20002074 (this one has 3 0's 0 between 45 and 2 and "-")
00450020002074 (this one has 2 0's 0 between 45 and 2 and no "-")
My understanding is that the Replace will strip the special character "-" and "0" and compare only on the remaining numbers: 452274 (no 0's or "-")
On my end, the update query has 0 records to update.
If I MANUALLY
remove the "-" in import-CSM2 then it will update but the Replace is suppose to do this automatically (I think)
Do you see what the issue is? thank you
Open in new windowThe Outer Replace removes the dash and the inner Replace removes the zeros.