>I figure there must be something out there for this problem. It is one I rememebr doing in a Fortran classs almost twenty years ago.
>
>I am comparing one number in TableA with another number in TableB. The number is of type character in both tables. If I find the number in TableB, I use a couple of the fields in that Table. I use the Left Join clause to accomplish this. Here's the problem. If I have 22222 and the number should be 222225, I have no way to know that unless I go through and use all ten numbers, (0-9) on the end of that number until i find the right number. I don't always have a check that this is the right number unless I compare the Business name which is not always provide. Any clue as to how I should handle this? Thanks in advance for your help on this issue and happy holidays.
>
>Randall

Why don't you just compare the VAL() of the fields?