M
Mike
I am working with two tables. Each table contains a field for a zip code.
Table A has an 11 digit zip code and Table B has an 11 digit zip code. I
currently run a join query to capture all matching records.
Table B also has zip codes less than 11 digits. I am trying to write a query
which will take each zip code less than 11 digits and match on the length of
the string to Table B. The string length can be between 5 and 9 digits. If
there a way to do this?
Thanks,
Mike
Table A has an 11 digit zip code and Table B has an 11 digit zip code. I
currently run a join query to capture all matching records.
Table B also has zip codes less than 11 digits. I am trying to write a query
which will take each zip code less than 11 digits and match on the length of
the string to Table B. The string length can be between 5 and 9 digits. If
there a way to do this?
Thanks,
Mike