21 Replies Latest reply: Apr 13, 2011 8:38 AM by Deepak Vadithala RSS

    Return Last Sting In Field

      Hi All,

      I have this set of data

      Claimant TypeClaim NumberVer NoPayment ReservesRecovery ReservesPaymentsRI RecoveriesNon RI Recoveries
      ADRS1002021925.000.000.000.000.00
      ADRS1002022925.000.000.000.000.00
      ADRS1002023925.000.000.000.000.00
      PIRS10020214585.000.000.000.000.00
      PIRS10020224585.000.000.000.000.00
      PIRS10020234585.000.000.000.000.00
      TPRS10020211000.000.000.000.000.00
      TPRS10020221000.000.000.000.000.00
      TPRS10020231000.000.000.000.000.00


      I wish to return the maximum Ver No and then the corresponding data with that row ( See Below ). I have used the MAX function in an expression to select the maximum Ver no. What expression can i use to return the string which corresponds with the rest of the data on the Max Ver No field?

       

      Claimant TypeClaim NumberVer NoPayment ReservesRecovery ReservesPaymentsRI RecoveriesNon RI Recoveries
      TPRS10020231000.000.000.000.000.00
      PIRS10020234585.000.000.000.000.00
      ADRS1002023925.000.000.000.000.00


      Thanks in Advance

      Regards
      James