How extract number from column
We want to replace this number with xxx-xx-xxxx
table A has 2 columns, column1 is primary key and column2 has value , CLMS NSSN 111-22-3333
select * from A;
column1 column2
1 CLMS NSSN 111-22-3333
2 GAVE PH 111-22-33333
3 PROP MGR GV SSN 222-22-2222(?)
How can I replace CLMS NSSN 111-22-3333 into CLMS NSSN xxx-xx-xxxx and PROP MGR GV SSN 222-22-2222(?) into PROP MGR GV SSN xxx-xx-xxxx(?)?
Thanks,
Tracy