Derived Field help ~ REPLACE??? function

[abowling]

I need a derived field to change the SSN from

123-45-6789 to XXX-XX-6789


Any help would be greatly appreciated.

 

[Atrzy]

Try this (Example is with basic PS_Employees table):

1st Derivied Field
SUBSTR("PS_Employees.SSN",6)

2nd Derived Field
Use concatenation to combine 'XXX-XX-' with first derived field

 

[abowling]

that worked, thanks a lot for your help!