I need a small SQL script that will take four fields from a table and randomly swap them with different records. Example: Take Field 1, go through each record and randomly swap the Field 1 data with another Field 1 record in the table, go to Field 2 and do the same, Field 3 and then Field 4. It must do this for each record to get as randoma a result as possible. I'll probably run the script a few times on the table data. None of the fields will be key fields. The reason is to take an existing DB to use in a test environment. I have attached a script to allow you to create the table. This is a pretty straightforward script and I would expect it done in no more than 1 day.