Hi.

I need a tool for manipulating the data in my tables. I want:
1. The tool doesnt' touch the primary key of the tuples in the table
2. Mix the rest of the column, so, everybody'll never know which primary key correspond to the rest of columns.

I don't know if I can do it with SQL.

That is for testing.

Look at the ENCRYPT() function. You'll need to process each column value separately.

Yup...you want to create development data...what happends if the PK is an SSN..

Do you need to scramble all of the elements?