Blanking out first five digits of a soc sec # 2

[choochoowinn2009]

Hi,

How would you write a formula to blank out the first five digits of a social security number?

The output would be like XXX-XX-1111.

Thank you!

C

 

[infinitizon]

try right({social security number}, remaining fields you want to show)
e.g right(00012344, 5) should give 12344.

Hope it helps

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

 

[lbass]

Just a tweak:

"XXX-XX-"+right({table.ssn},4)

-LB

 

[choochoowinn2009]

Thank you. It works!!!

Have a good day,
--C