5 Replies Latest reply: Mar 20, 2017 3:15 AM by Rishi Minawala RSS

    Taking Max value from and alphanumeric field

    Rishi Minawala

      I have an alphanumeric field where I need to take the first four characters and then to take the largest number value.


      Field example:             Desired Output


      S876987630987                       8

      A33027889085F                        3





      I have tried to use LEFT(Field,4) and then tried a number of things but to no avail.



      Any help would be great


      Thanks in advance.