matching number with leading zeros

[webisti]

Hi

I have two tables
table a contains a list of numbers (ie invoice)
10215
10316
15751
16925
016744
012458

table b contains the same numbers but with leading zeros:
000000010215
000000010316
000000015751


000000016925
000000016744
000000012458

how can I make a match query to show me the results 1 ie: 10215 = 000000010215
10316 = 000000010316
012458 = 000000012458

I tried the opposite with a module stripzeros() but that gives me wrong data as it removes all the leading zeros.

any ideas?

Thanks

Webisti

[lfpm062010]

This is one way to solve your issue.

Create a query for table b and convert the leading zeros number and use that query to match back to table a.

Like,

1) Query for table b:
SELECT CLNG(LEADINGZEROFIELDNAME) AS SOMEFIELDNAME FROM TABLE_B;

2) Match/JOIN back to table a.
SELECT A.NONLEADINGZEROFIELDNAME, B.SOMEFIELDNAME
FROM TABLE_A INNER JOIN TABLE_B ON A.NONLEADINGZEROFIELDNAME = B.SOMEFIELDNAME;