This content has been marked as final. Show 5 replies
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
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.