Hello gurus,
I have a column which has a value ASFDSFS00001
I need to increment the last digit to make it to the new value as ASFDSFS00002 then ASFDSFS00003 onwards
How to achieve this by extracting the last digit and increment the value by i.e
ASFDSFS00001
ASFDSFS00002
ASFDSFS00003