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.