Query from two columns in table

[bflan0524]

hello, in the example below if i know the # in column A exist in there, and all is what is in column B, is there a query i can do in column C to match the columns where it identifies what is in column B and finds the match in column A for it

Column A	Column B	Column C
600060054576700042	6000600545767	?

 

[alansidman]

this will return either a True or False =LEFT(A2,LEN(B2))=B2

 

[bflan0524]

this will return either a True or False =LEFT(A2,LEN(B2))=B2

i am prob not explaining well, column B is 13 characters, column A has 18, is there a way to look at the account in column B and see if there is a match in column A, which would then return the full # in column C if that makes sense? so ideally its a query that is searching column A for the 13 characters in column B and if identified it would return in column C

 

[Micron]

something along the lines of this in a query calculated column, perhaps:
IIF(Instr([Column A],[Column B])>0,[Column A],"")

 

[alansidman]

=if((LEFT(A2,LEN(B2))=B2)=TRUE, A2,"")

 

[Micron]

I don't think you can use If in an Access query?

 

[Marbles]

Do you want them to match exactly, or for all of B to be inside A.

 

[jackd]

In your example in post #1, what should be in column C?