Hi SPR,
Thanks, it works. I need one more concern,
Provno Liceno
110987-A85 110987
117866-B85 117866
11347 34567
002478-A19 002479
My report needs to look like as below,
Provno Liceno
11347 34567
002478-A19 002479
In above example, need to get only the records which are different(only 3 and 4 row) and the 1 and 2 row considered as same so it should be eliminate from the report. The reason is that the first 6 numerics match the numerics contained in the liceno field. In essence 119966 matches 119966.
Please let me know .
Thanks.
... View more