title: How do I replace a SSN with a 9 digit random number in SQL Server 2008R2?
body: <p>To satisfy security requirements, I need to find a way to replace <a href="https://en.wikipedia.org/wiki/Social_Security_number" rel="nofollow noreferrer">SSN</a>'s with unique, random 9 digit numbers, before providing said database to a developer.  The SSN is in a column in a table of a database.  There may be 10's of thousands of rows in said table. The number does not need hyphens.  I am a beginner with SQL and programming in general.</p>
  
  <p>I have been unable to find a solution for my specific needs.  Nothing seems quite right.  But if you know of a thread that I have missed, please let me know.</p>
  
  <p>Thanks for any help!</p>