What would be the best way to do this?
I have a table with ID’s that are good and bad, like:
0102000
0105015
0105000
……
I need to go to another table and compare each ID starting with the first digit to the last and see if there is a match. That is, I begin my SCAN with 010200. Now in the good table I may find 0102, that would match my first 4 digits but I need to continue and see if there is a match for the next digit till the last (in this case of 010200)
If I find a match, keep on scanning, if not apply it as Invalid and keep scanning.
Any help would be appreciated.