Post reply

scrambling number

  • January 23, 2003 at 10:24 am

    #105614

    I have to send something out in the mail and I want to use the persons ssn are their unique identifier. I was wondering how the best way to scramble the numbers would be. I would prefer not to just rearrange the order but rather something a little more sohpisticated.

  • January 23, 2003 at 11:13 am

    #447071

    Unless you actually want to send mailings with a readable SSN, I would probably create a match table so that you wouldn't need to actual send out any variation/encryption of SSN's, yet can still maintain uniqueness via the SSN.

    create table SSNMappings (SSN varchar(11), EmployeeMailID int IDENTITY (1000,1) )

    insert into SSNMappings

    select SSN from <table that Holds SSN's>

    -J

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply