Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    39

    Unanswered: SSN masking help needed

    Hey all,

    So I have a column of SSNs and need to convert all of their first 5 digits as zeros, while still keeping the last 4 digits the same. Any suggestions how to do this? Maybe in an update query or something?

    Example SSN: 123456789
    Needs to be converted to: 000006789

    Much thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    display as
    "00000" & right([SSN],5)
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •