I have 2 number fields and I have to concat them

[vij1]

Hi ,

I have 2 number fields and I have to merge them.

Example:

A	B	result
21333	5667	213300005667
23434	657896	234340657896

You can see the result column it contains exact 13 digit number wherein the zero is padded between the two numbers. So how can I achieve this result?

Thanks in advance!

[stevejoyce · Accepted solution]

A & repeat(0,13-(Len(A) + Len(B))) & B

[vij1 · Accepted solution]

Thank you!

That works for me!!