Hi,

I have a table name CustUsers. In this table, there is a field name: PWD

I have refreshed the production database into the test. This field has about 200 records and these records are passwords created by users from the application. When i restored the  prod database into the test,  there will be 200 passwords. I want to keep just one password for all of the users in the test database for the testing purpose and to troubleshoot database issues, and i want all users to use the same password. How can i update these 200 records in the test database table?

Thanks for your help and let me know if the question is not clear.