Ask Tom "Stripping special characters" - Oracle
How would you go about stripping special characters from a partnumber. I do not know of an Oracle function to do this. Are there any packages that do this? ... There is no native function but we can build one. It could be: ops$tkyte@8i> create or replace ...