getting numbers from a database column

Question

I have a column in my database that i want to check the number before i generate a new one so that the new one is one digit higher with the format "yyMMdd" - ooo