Addition between padded numbers (strings) and numbers
I've looked through the forums and I couldn't quite find an answer. So here's my issue. I have a list of jobs and they have job numbers. They are in the format 13-102C. They are made up of the fiscal year, a '-', the job number and a category. I have a query (within a process) that extracts/returns the job number
Declare MyJobNumber string(4);
Begin
select unique substr(Job_Number, 4, 3) into MyJobNumber
from Jobs;
End;
I need to increment this job number by one but am not sure how to do so. I'm guessing the result that is returned is more so a string so its a little more than simple addition. I need a little help on the issue. Also any suggestions or corrections to my current process would help as well. Thanks in advance.