I have a column in the database with the name of codigo
, in which the formatting looks like this:
18000001
Where 18 means the year we are and 1 is the code for each result. Knowing that this code can be greater than 1 I type 18000011 and so on, I need to remove only the final value before it reaches zero,
1800044 - Preciso pegar só o 44
1800444 - Preciso pegar o 444
1804444 - Preciso pegar o 4444