Remove Hyphens in Oracle SQL
I have a ssn field.
The field has hyphens in it.
Ex. xxx-xx-xxxx
How can I just extract the numbers without the hyphens?
The field has hyphens in it.
Ex. xxx-xx-xxxx
How can I just extract the numbers without the hyphens?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
awking00
Depending on your version, I believe you can also just do replace(ssn,'-')
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's quite common to express ssn in the xxx-xx-xxxx format and I suspect eliminating the hyphens may be all that's needed. There is also something called a PTIN (stands for preparer tin) that begins with the letter "P" which wouldn't be retained if just the digits are retrieved.
if you need to preserve a "P" as well as digits and exclude all others then simply add P to the "keep" list.
regexp_replace(ssn,'[^0-9P
regexp_replace(ssn,'[^0-9P