I have a text field (JobNumber) that is an alpa prefix combined with a number. Currently it is always a one digit alpa prefix.
Several queries use Mid(JobNumber,2) and Left(JobNumber,1) to get just the prefix or the number without the prefix.
We now have the capability of having a 2 digit alpha prefix but all existing records will retain the 1 digit alpha prefix
Are there functions that I an use to replace the MID and LEFT to return ONLY the alpha prefixes (1 or 2 digits) and ONLY the number part of the JobNumber?