Expression issue

[paulwalker]

Hi Community,

Table:

ID

000123

001234

000009876

Table2:

ID

123

1234

9876

i have 2 tables ID is the common field, but i don't want 0's of the Table.

Thanks in Advance..............         

[simondachstr]

Format ID from the first table to a number before loading it using num().