Data Base Find and Replace
If I have 3 fields that I want to do a find and replace on what would the case or if statment look like. I have about 30,000 records and it needs to do the following:
Field 1 is now Doug and I need it to be replaced by Jonh
Field 1 is now Matt and I need it to be replaced by Chris
Field 1 is now Steve and I need it to be replaced by Tony
I want to script it so I can do it each week. Each week I do an import of data and then I want to run this script to make the necessary find and replace.