Hello,
I have 2 tables, all formatted as text.
Table one has a filed where the leading zero's are truncated. That is 0005117 appears as 5117.
Table 2 contains the leading zero's.
I am trying to write a query that will give me a match when theis occurs.
That is 0005117=5117
Thanks
I have 2 tables, all formatted as text.
Table one has a filed where the leading zero's are truncated. That is 0005117 appears as 5117.
Table 2 contains the leading zero's.
I am trying to write a query that will give me a match when theis occurs.
That is 0005117=5117
Thanks