Post reply

generating a unique number from an existing field

  • April 13, 2004 at 2:50 pm

    #108005

    I would like to take a social security number and generate a unique identifier from it to use as a unique ID. Is their a secure built in function in sql server for thsi purpose? Any other suggestions.

  • April 14, 2004 at 1:05 am

    #502659

    Sorry, but isn't a Social Security Number uniquely enough?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 14, 2004 at 7:44 am

    #502719

    I don't want to send SSN to a vendor.

  • April 14, 2004 at 8:06 am

    #502731

    Okay, that's a very valid reason

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 14, 2004 at 11:01 am

    #502786

    Create a table With SSN and an identity column. Make sure that the SSN is the Primary Key and use the table as a Lookup


    * Noel

Viewing 5 posts - 1 through 4 (of 4 total)

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