How to scramble data in SQL?

Question

We have some data in the SQL server table that needs to scramble. Some data are string and some data are date.

What is best way to do this?

Answer 1

Are you talking about Obfuscating your SQL Server Data? (To create a development version based on the production data without exposing the production data itself)

Or do you want it encrypted?