How to link two field with different length but same data

[IChang]

Hello,

I need to link the following field A, B
A ( string, length 6) ex: 001234
B ( string, length 4) ex: 1234

they have the same last four numbers.

How can I write a formula to make them equal to each other? Thank you.

 

[lbass]

Try:

right({table.A},4) = {table.B}

-LB

 

[synapsevampire]

If you want more detailed help, or solutions that can be performed by the database to allow for optimal performance, you need to post basic technical information:

Crystal version
Database/connectivity used

I would think that a Command object with the join resolved in SQL would be best.

-k