Return Last String In Field

[#1]

Claimant Type	Claim Number	Ver No	Payment Reserves	Recovery Reserves	Payments	RI Recoveries	Non RI Recoveries	Incurred	Status
AD	RS100202	1	925.00	0.00	0.00	0.00	0.00	925	O
AD	RS100202	2	925.00	0.00	0.00	0.00	0.00	925	O
AD	RS100202	3	925.00	0.00	0.00	0.00	0.00	925	O
PI	RS100202	1	4585.00	0.00	0.00	0.00	0.00	4585	O
PI	RS100202	2	4585.00	0.00	0.00	0.00	0.00	4585	O
PI	RS100202	3	4585.00	0.00	0.00	0.00	0.00	4585	O
TP	RS100202	1	1000.00	0.00	0.00	0.00	0.00	1000	O
TP	RS100202	2	1000.00	0.00	0.00	0.00	0.00	1000	O
TP	RS100202	3	1000.00	0.00	0.00	0.00	0.00	1000	O

i have this original set of data.

i need a table which returns the highest Ver No. for each claimant Type. and all the other records which correspond to that max version number. (see below)

Claimant Type	Claim Number	Ver No	Payment Reserves	Recovery Reserves	Payments	RI Recoveries	Non RI Recoveries	Incurred	Status
TP	RS100202	3	1000.00	0.00	0.00	0.00	0.00	1000	O
PI	RS100202	3	4585.00	0.00	0.00	0.00	0.00	4585	O
AD	RS100202	3	925.00	0.00	0.00	0.00	0.00	925	O

Thank you in advance

[#2]

Try creating a straight table with set analysis expression such as:

only({$<VerNo=$(=max(VerNo))>} PaymentReserves)

[#3]

I have tried it. why doesn't this work? forgive me i am new to the systme still.

only({$<[Claim Transaction Sequence Number]=$(=max([Claim Transaction Sequence Number]))>} [Claimant Payment])