Fetch specific characters in a data string

Fetch specific characters in a data string

Is there a way to fetch a specific character in a data from a form field? This is my situation:

I have created a database of car plate numbers (i.e. ABC123, ARX899, etc) which we are managing. Now I wish to be able to fetch the last digit of the plate number and create an automatic email notification based on the last digit of the plate number:

If the ending plate number is "1", then we shall receive an email on January 1 to alert that the car needs to be registered on January. If the ending plate number is "2", the we shall receive an email on February 1. If the ending plate number is "3", the we shall receive an email on March 1....and so on and so forth.


I have already figured out how to do the email notification, but I can't seem to be able to extract the last digit of the plate number. I am thinking that the "FETCH" function will do the trick, but it seems to only get the full data field content. and not just part of it.