generating a unique number from an existing field
-
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.
-
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] -
I don't want to send SSN to a vendor.
-
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] -
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