I have a table field named Retail_Service_Code.
It has values like FPR (SVC 1008). I need to retrieve the number part from this value. I've never used REGX_SUBSTR before but would it be appropriate to use it here? If not, what would be more appropriate? The number can be 4, 5, or 6 digits long, by the way.
Thanks in advance for your assistance!