Johnwm,
Thank you, your example code worked just fine! I am new to SQL, so I knew that it could be done with an update statement, and there it is! I have definitely learned my lesson this time, I will make a duplicate database and test my custom scripts on there first! Thanks again.
Hello, I have the following problem:
1. I have a MS SQL 2000 database with a table of user accounts called tbl_User.
2. A faulty script was run on the data in the table and, it deleted each user's first and last name.
3. I was able to reconstruct the data and have created another table called...