I have a SQL table in my test database with some columns containing sensitive data. The columns are "LastName" and "FirstName". I want to scramble the data in these 2 columns. I don't care if the data is even readable after scrambling.
For example, "John" can be "vspx" when scrambled. Does anyone have a bit of SQL that will do this easily?
View Complete Post