PL/SQL - strip off special characters at beginning and end of string
Hello - I know how to use the replace function to get rid of special characeters (/,',%,_, etc) in a string. But I only want to get rid of them at the beginning and end of string. I figure that I could do a loop and use substring to test the first character, remove it, test the second, etcetera and stop once I hit a non-special characeter. And then repeat for the characters at the end of the string. But does anyone have a better suggestion than that?
I am using Oracle 9i. Thank you very much for your assistance.