Is it possible to join two fields based on partial matching info 1

[jenni]

Table A has a column with a 10 digit number, Table B has the begining six of that 10 digit number...

I want to run a query based on the six digits pulling out all that are similiar in 10 digit form from Table A...can I join those fields somehow? I have no other field where I could join the tables and I want to avoid adding a new column to table A, where i copy the first 6 - just so i can match up.

Appreciate your help.

Thank you!

 

[GHolden]

If the 'numbers' are stored as text, you could join them like this...

SELECT fldOne,fldTwo,fldThree,etc..
FROM TableA INNER JOIN TableB
ON LEFT(TableA.fldOne,6) = LEFT(TableB.fldTwo,6);



There are two ways to write error-free programs; only the third one works.

 

[jenni]

Thank you very much....it worked!