In Oracle, I'd like to write some SQL to replace the last 3 characters of a string with 3 or 4 different characters. So if the last 3 characters of a string are "-7M", I want to change them to "-10M". If the last two characters are "-14M", I want to change them to "-20M". For example, the if the value of the field is 123456-7M, I want to change it to 123456-14M or if the value of the field is 25689-14M I want to change it to 25689-20M.
I've googled this every way I can think of but can't find an answer.
Can someone give me a hand with this?
Thanks in advance