Unanswered: Removing or Changing digits in a number
Okay, this one should be simple and can be solved in one of two ways. I have two seperate tables with a 12 digit identifying number that is ALMOST exactly the same in each. I am trying to match up these two tables, which works amazingly well, except for the occasional case where the 12 digit ID (which is called API) ends in 01, instead of 00. The last two digits do not make a difference at all, but in one table it will end in 00 and the other it will end in 01, even though they are the same record.
Basically, it looks like this...
Table 1---------------Table 2
So basically, in my final query, the last entry will not show up since these two are not related by this API (ID) number. Does anyone know of a way to either replace the 01 on the end with 00... OR to remove the last two digits?